+23I have a date, some weeks, and some holidays.
I need to add the weeks to my date and exclude all holidays and weekends.
I’ve used the WORKDAY function. However, I’m a little uncertain how to treat my weeks. Should I multiply them by 5 (since there are 5 working days in a week) or by 7 (since there are 7 days in a week, and the function will filter out all the weekends)?
Best answer by Alexey_Gusev
Hi,
In short - multiply by 5. Example below for 4 weeks
If you want to consider holidays, add them as third parameter, like ‘2025-05-21, 2025-05-30, 2025-06-15’
To make formula work in future years, if you have a static list of holidays, use smth like
WORKDAY({Date_Field},20,
SUBSTITUTE('Y-05-21, Y-05-30, Y-06-15', 'Y', ''&YEAR(TODAY())))
+25Hi,
In short - multiply by 5. Example below for 4 weeks
If you want to consider holidays, add them as third parameter, like ‘2025-05-21, 2025-05-30, 2025-06-15’
To make formula work in future years, if you have a static list of holidays, use smth like
WORKDAY({Date_Field},20,
SUBSTITUTE('Y-05-21, Y-05-30, Y-06-15', 'Y', ''&YEAR(TODAY())))
+23
Especially for your static holiday list, as I ended up creating a linked table just for holidays, as I couldn’t see how to make recurring dates work…
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.