filtering out holidays if fall between start and end date

[LuigiX]

I need to calculate the end date of a course of 156 days duration and adjust for holidays if they occur during the course.

There may be one or two X 1 week holidays (5 April to 12 April and 20 September to 27 September) between the start date and end date depending on the start date.

Is there a quick way of doing this in code?

 

[Rich]

If you search here for Holidays I'm sure you'll find your solution, there have been several posts with functions to do this, provided you have the holiday dates stored in a table.

 

[LuigiX]

Hi Rich

I checked that code - its all good stuff. But is there any samples that calculate and end date based on a start date plus x days less holidays.

All that stuff works on end date and start date to calculate elapsed days.

Cheers

Luigi