Calculate SLA ( Service Level Agreement ).
If, for example, the date you received the order is in a1, your service deadline
is:
=a1+2
All you need to do is compare today's date to the deadline, as in:
=if(today()a1+2,"missed deadline","still got time")
--
Regards,
Fred
"Thyag" wrote in message
ps.com...
Hi All,
I need to calculate the SLA for a project.If I have received an order
today there is a two day SLA Period.The thing is I am not sure how to
construct a formula which gives me the status whether the output
happened after 2 days has crossed the SLA.
I know it may not be so clear for every body to understand.
If any query revert again I will emphasis the requirement.
Thanks
Thyag
|