View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Fred Smith Fred Smith is offline
external usenet poster
 
Posts: 623
Default 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