formula problem

cameron_kyle

Active Member
Joined
Jan 14, 2006
Messages
313
i am so out of touch with how to construct formula, i hope someone may lend their expertise

=DATEDIF(TODAY(),M9,"d")


the above formula counts how many days till the date in M9 is met, is it possible to add onto this formula so it states that if the date in M9 is less than today’s date it displays “MISSED SLA”


thanks kyle - cameron risi
 

Some videos you may like

Excel Facts

Save Often
If you start asking yourself if now is a good time to save your Excel workbook, the answer is Yes

yee388

Well-known Member
Joined
Mar 7, 2004
Messages
1,374
What about:

Code:
=IF(M9<TODAY(),"MISSED SLA",M9-TODAY())
?

Edited to correctly show formula
 

awalle

Board Regular
Joined
Jul 12, 2006
Messages
56
Try this:

=IF(ISERR(DATEDIF(TODAY(),M9,"d")),"MISSED SLA",DATEDIF(TODAY(),M9,"d"))


Hope this can help you.
AWalle
 

Watch MrExcel Video

Forum statistics

Threads
1,114,090
Messages
5,545,893
Members
410,711
Latest member
Josh324
Top