dpaton05
Well-known Member
- Joined
- Aug 14, 2018
- Messages
- 2,352
- Office Version
- 365
- 2016
- Platform
- Windows
What is the formula to calculate the number of weekdays between 2 dates. I need it to not include public holidays, for instance, if I had a start date of 22/12/19 with a finish date of 26/12/19 (5 day period), I need the formula to return 3 weekdays, not 5 days as the 22nd is a sunday and the 25th is a public holiday.
- Start date is in B13
- Finish date is in B14
- There is a range of public holidays in G87:DO97