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

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

Hi Thyag,

I understand that you need to calculate the SLA for a project with a two-day SLA period. To determine whether the output happened after two days has crossed the SLA, you can use the following formula:

In this formula, [Order Date] refers to the date the order was received. The TODAY() function returns the current date, and subtracting the order date from it gives the number of days since the order was received. If this number is greater than 2, the formula returns "SLA Missed". Otherwise, it returns "Within SLA".

You can enter this formula in a cell in your spreadsheet and replace [Order Date] with the cell reference that contains the order date. This will give you the status of whether the output happened within or after the SLA period.

1. Enter the formula
   Formula:

   =IF(TODAY()-[Order Date]2,"SLA Missed","Within SLA") 

   in a cell in your spreadsheet.
2. Replace [Order Date] with the cell reference that contains the order date.
3. The formula will return either "SLA Missed" or "Within SLA" depending on whether the output happened within or after the SLA period.