when a report is due within 60 days of its expiration date to our customer. Here is a sample of the report DO Expires Due Date Submitted

5004 30-Nov-11

5029 30-Dec-11

My formula is =IF(B2<"12/01/2011", "Y","N").B2 = Expires; for due date, I simply enter +B2+60 for the due date and that worked fine.

The problem is I am getting a "Y" for every cell instead of an "N" for cells that have an expiration date greater than 12/1/2011. What I want is if the expiration date is 11/30/2011, then C2 =Y and if not, then C2 is N. Also, I have not tried the formula for this part since I cannot get the first formula to work but I would like for the Submitted Date cell to turn bold. Please help.

=IF(B2<DATEVALUE("12/01/2011"), "Y","N")I would like for the Submitted Date cell to turn bold.

Use conditional formatting.

Razor2.3 If you look at the formula I provided, it is the same one that you are suggesting and it is not working for me.

Razor2.3's Formula: =IF(B2<DATEVALUE("12/01/2011"), "Y","N")

Your Formula:

=IF(B2<"12/01/2011", "Y","N")

Very different animals.

If I put today's date in B2, your formula returns "Y" while Razor2.3's returns "N".

In Excel's eyes, DATEVALUE("12/01/2011") is

verydifferent than "12/01/2011".

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Razor2.3 Please forgive me. I was looking at the formula wrong and misunderstood that I needed to put the word DATEVALE in my formula. It worked perfect. Thanks again to you and also to DerbyDad03 for explaining and clearing up my oversight.

Ask Your Question

Weekly Poll

Have you played Jackbox during the pandemic?

Discuss in The Lounge

Poll History