Extend an end date of a date range to account for holidays within the range

(0) Share

Report

Posted on by Northern_Flyer

I have a table of planning data, each row represents an activity, each activity has a start and end date.

I also have a list of holidays currently (25/Dec/23, 26/Dec/23, 27/Dec/23, 28/Dec/23, 29/Dec/23, and 1/Jan/24

I'm trying to count how many holidays there are in each activities date range, so I can create a corrected end date that would represent the original end date + the number of holidays.

e.g.

PR0910 - Activity 1, Start = 4/Dec/23, End 12/Feb/24 - This includes 6 holidays, so I'd end up with a corrected end date 6 dats later then 12/Feb/24.

I've managed to calculate the Net Work Days where Weekends are Saturday and Sunday, however I have activities taking place where Friday and Saturday represent the weekend, however the project has a common set of holidays hence I really only need to extend End dates for activities date ranges include holidays.

Any thoughts please.?