Formula for SLA by excluding weekends (Fri & Sat) & Holiday

[Ankit_Kumar]

Hi Everyone,

I have a data with Start date with time, End time with time, and also friday & saturday are weekends so how can I calculate the SLA

For example:-

Cell A2 contains start date and time :-5/1/15 10:00 AM

Cell B2 contains End date and time :- 5/31/15 7:00 PM

Cell D2:D10 contains holidays.

thanks in advance

[cbatrody]

Hi,

Try the following function:

=NETWORKDAYS.INTL(A2,B2,7,I$2:I$10)

where A2: Start Date
B2: End Date
7 stands for Weekly Offs (Friday, Saturday)
I$2:I$10 = List of holidays excluding weekends

[cbatrody]

Hi,

If you want to calculate the SLA in hours, use the following formula:


=((NETWORKDAYS.INTL(A2,B2,1,I$2:I$9))-2)+((1-(A2-INT(A2)))+(B2-INT(B2)))

[daddylonglegs]

......so how can I calculate the SLA......

So, what's the required result for your example?