dpaton05
Well-known Member
- Joined
- Aug 14, 2018
- Messages
- 2,352
- Office Version
- 365
- 2016
- Platform
- Windows
I have 2 cells that have a start and an end date in them.
I need the formulas to not count the start and the end date as at the moment, the formulas include the start and end dates.
Can someone help me adjust the formulas so they do not count the start or end dates in the calculation please?
- B8 is the start date
- B9 is the end date
- I have a list of public holiday dates in the range Sheet2!G87:DO97.
- The formula to calculate the weekdays in the period between B8 and B9 is =NETWORKDAYS.INTL(B8,B9,1,Sheet2!G87:DO97)
- The formula to calculate the satudays is =INT((WEEKDAY($B$8- 7)-$B$8+$B9)/7)
- The formula to calculate the sundays is =INT((WEEKDAY($B$8- 1)-$B$8+$B9)/7)
- The formula to calculate the public holidays is =SUMPRODUCT((Sheet2!G87:DO97>=B8)*(Sheet2!G87:DO97<=B9))
I need the formulas to not count the start and the end date as at the moment, the formulas include the start and end dates.
Can someone help me adjust the formulas so they do not count the start or end dates in the calculation please?