WORKDAY
Formulas / WORKDAYCalculate a date n working days in the future or past.
WORKDAY(start_date, days, [holidays])
- start_date - required, the date from which to begin
- days - required, the number of days before or after start_date
- holidays - [OPTIONAL] a list of non-working days
Examples
=WORKDAY("1-Jan-2021",1,F5:F13)The WORKDAY function can be used to calculate the date after a certain number of working days, excluding holidays and weekends. For example, this returns 4-Jan-2021 because January 1 is a holiday and Saturdays and Sundays are also excluded.
=WORKDAY("31-Dec-2020",-1,F5:F13)The WORKDAY function can also be used to calculate the date before a certain number of working days. For example, this returns 30-Dec-2020 because December 31 is a holiday and Saturdays and Sundays are also excluded.
=WORKDAY("1-Jan-2021",5,F5:F13)The WORKDAY function can be used to calculate the date after a certain number of working days while skipping multiple holidays at once. For example, this returns 8-Jan-2021 because January 1 and 2 are holidays and Saturdays and Sundays are also excluded.
=WORKDAY("31-Dec-2020",-5,F5:F13)The WORKDAY function can also be used to calculate the date before a certain number of working days while skipping multiple holidays at once. For example, this returns 24-Dec-2020 because December 31, 29, and 28 are holidays and Saturdays and Sundays are also excluded.
Summary
The WORKDAY function is used to calculate a date from a formula, returning a number representing the date that is either before or after a specified number of working days, with parameters to indicate which days are weekend days.
- The WORKDAY function calculates a date n days in the future or past, excluding weekends by default.
- The WORKDAY.INTL function can customize which weekday days are considered weekend days, allowing you to specify which days should be excluded.
- The WORKDAY function can be used to calculate dates such as due dates, delivery dates, and other dates.
Frequently Asked Questions
What is the WORKDAY function?
What does the WORKDAY function do?
What are some examples of how I can use the WORKDAY function?
- You can use the WORKDAY function to calculate the date of a deadline.
- You can use the WORKDAY function to calculate the date of a meeting.
- You can use the WORKDAY function to calculate the date of an upcoming event.
- You can use the WORKDAY function to calculate the date of a payment.
How do I use the WORKDAY function?
