I am trying to create a formula to alert me in advance

January 30, 2012 at 08:40:13
Specs: Windows XP
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.


See More: I am trying to create a formula to alert me in advance

Report •

#1
January 30, 2012 at 09:21:28
=IF(B2<DATEVALUE("12/01/2011"), "Y","N")

I would like for the Submitted Date cell to turn bold.
Use conditional formatting.

How To Ask Questions The Smart Way


Report •

#2
January 30, 2012 at 11:59:54
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.


Report •

#3
January 30, 2012 at 12:17:54
Doubtful; mine's 11 characters longer.

How To Ask Questions The Smart Way


Report •

Related Solutions

#4
January 30, 2012 at 13:23:24
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 very different than "12/01/2011".

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


Report •

#5
January 31, 2012 at 05:42:05
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.


Report •

Ask Question