Calculate SLA ( Service Level Agreement ).

  • Thread starter Thread starter Thyag
  • Start date Start date
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
 
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")
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Calculating difference between times on 2 dates 4
Count days excluding Weekends 2
Calculating date/time 1
Time Expired on a Service Record to Calculate SLA 7
calculating a formula for a service level 6
Help with Multi-Condition Formula 2
SLA - Downtime calculation 1
Interest Calculations 6

Back
Top