Note that WORKDAY willautomaticallyexclude Saturdays and Sundays but will only exclude holidays if they are provided.
The goal is to calculate a date that is 5 working days after July 1, 2024.
Remember that holidays must be valid Excel dates.
The name of the holiday makes no difference.
Of course, in real life, you will not hardcode dates directly into formulas.
You will instead refer to dates on the worksheet with cell references.
Notice that WORKDAY automatically excludes Saturdays, Sundays, and overlapping holidays in the calculated result.
The second formula (G6) excludes weekendsandholidays and returns January 2, 2025.
The shading and highlighting is applied withconditional formatting.
For a full explanation with details,see this page.
Example - is this date a workday?
One problem you might run into is how to test a date to determine whether it is a workday.
you’re free to use WORKDAY for this task, but the formula is not immediately obvious.
it’s possible for you to see this approach in the worksheet below.
Custom Weekends
By default, WORKDAY will exclude weekends (Saturday and Sunday).
If you should probably customize which days of the week are considered weekend days, use the more robustWORKDAY.INTLfunction.
WORKDAY.INTL can be configured to treat any day of the week as a working or non-working day.
NETWORKDAYS automatically excludes weekends (Saturday and Sunday) and canoptionallyexclude a list of holidays supplied as dates.
…
NETWORKDAYS.INTL Function
The Excel NETWORKDAYS.INTL function calculates the number of working days between two dates.
