IF statement in Excel using today's date

Microsoft Excel 2003 (full product)
December 30, 2010 at 06:44:37
Specs: Windows XP
I am looking to make an IF statement for the following:

In cell J1 there is a date in it and I want I1 to read "Calibration Due" if the date in column J is less than or equal to 45 days from today's date, and remain blank if this is not true.

Any help would be great!

Thanks!


See More: IF statement in Excel using todays date

Report •


#1
December 30, 2010 at 08:06:19
Try:

=IF((J1+45)>=TODAY(),"Calibration Due","")

MIKE

http://www.skeptic.com/


Report •

#2
December 30, 2010 at 09:10:11
Thanks Mike! Just had to change it to a less than sign...thanks again!

Jillian


Report •

#3
December 30, 2010 at 09:36:25
Just had to change it to a less than sign

OOPS, sorry 'bout that.

Originally used this formula:

=IF(TODAY()>=(J1+45),"calibrate","")

When I changed it around, forgot to change the logic.

Glad you caught it.

MIKE

http://www.skeptic.com/


Report •

Related Solutions


Ask Question