SOLVED

Formula to calculate a resolution date excluding weekends

Copper Contributor

Hello,

I am trying to calculate a target date (Case Resolution Date) in Excel.

On my excel sheet I have columns called

"Date/Time Opened"

"Time Resolution hrs"

"Time Resolution Weekdays"

Basically I would like to calculate what would be the "Case Resolution Target Date". knowing that the date should only include weekdays (5 days a week) with 8hrs business hours.

For example A case with 

Date/Time Opened: 28/02/2020

and with a Time Resolution hrs: 144 

will equal to 18 weekdays 

So the Case Resolution Target Date will be 26/03/2020

As business hours are 8hrs.

But I am not able to put a valid formula to calculate  Case Resolution Target Date

Could anyone help?

Thank you

1 Reply
best response confirmed by hermy670 (Copper Contributor)
Solution

@hermy670 

That could be around function

=WORKDAY.INTL(C2,INT(D2/8),1)

the question is when are weekends (Sat,Sun or other days) and if Time Resolution Hrs is always multiplier of 8 or not.

1 best response

Accepted Solutions
best response confirmed by hermy670 (Copper Contributor)
Solution

@hermy670 

That could be around function

=WORKDAY.INTL(C2,INT(D2/8),1)

the question is when are weekends (Sat,Sun or other days) and if Time Resolution Hrs is always multiplier of 8 or not.

View solution in original post