formula problem

[cameron_kyle]

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

 

[yee388]

What about:

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

?

Edited to correctly show formula

 

[awalle]

Try this:

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


Hope this can help you.
AWalle