You’re offline. This is a read only version of the page.
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.?
Share
Report
All responses (
Answers (
883
