benposaner
New Member
- Joined
- Jan 7, 2021
- Messages
- 9
- Office Version
- 365
- 2019
- Platform
- Windows
Hi
Sure it's simple but can I use a formula to workout what working day of the month a particular date is?
Assuming Working week is Mon-Fri and Bank holidays are excluded.
For example today 7th January is 4th working day of the month. (1st is Bank Hol and 2nd & 3rd are weekend)
So 1st working day would be have been the 4th Jan, etc.
So the formula should return working day 14 for 21st Jan 2021
I've tried using WORKDAY.INTL, to also exclude weekends and Holidays, but can't figure out how use the (start_date, days) in the formula to tell me what the corresponding working day of the month would be.
Any help would be great.
Thanks.
Ben
Sure it's simple but can I use a formula to workout what working day of the month a particular date is?
Assuming Working week is Mon-Fri and Bank holidays are excluded.
For example today 7th January is 4th working day of the month. (1st is Bank Hol and 2nd & 3rd are weekend)
So 1st working day would be have been the 4th Jan, etc.
So the formula should return working day 14 for 21st Jan 2021
I've tried using WORKDAY.INTL, to also exclude weekends and Holidays, but can't figure out how use the (start_date, days) in the formula to tell me what the corresponding working day of the month would be.
Any help would be great.
Thanks.
Ben