Forum Discussion
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" Basica...
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.
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.