Calculate SLA ( Service Level Agreement ).

T

Thyag

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
 
F

Fred Smith

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")
 
Top