View Full Version : Excel - 'today' function
crazymom999
May 22nd, 2004, 02:04 PM
My spreadsheet is a service history. So i need date1 = last service, date 2 = 6 weeks later. But now i need an 'if' statement in a new column showing me if date 2 is past TODAY = overdue, 'if' not = ok. I work with 'if' statements, but i've never used 'today' as part of it. Can anyone help me, or at least point me in the right direction. I tried several things, but no luck yet and its driving me crazy. many thanks in advance.
VegasMAK
May 22nd, 2004, 05:11 PM
Hi
I think I know what you are looking for and, assuming D2 = date of last service + 6 weeks.
=IF(D2<TODAY(),"Overdue","OK")
should work.
Good luck
crazymom999
May 22nd, 2004, 07:33 PM
Excellent, brilliant - many thanks. You don't know how i get it to show RED if overdue, do you.
smurfy
May 22nd, 2004, 11:32 PM
Format>Conditional Formatting
If Cell Value is "Overdue" set format to red.
crazymom999
May 23rd, 2004, 10:45 PM
Thanks again, yet another problem solved.:wave: