Forum Discussion

hermy670's avatar
hermy670
Copper Contributor
Jul 21, 2020
Solved

Formula to calculate a resolution date excluding weekends

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

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

  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor

    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.

Resources