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
=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