WORKDAY

Formulas / WORKDAY
Calculate 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?
The WORKDAY function is a formula used to calculate a date. It returns a number representing the date that is a number of working days before or after a given date.
What does the WORKDAY function do?
The WORKDAY function calculates the serial number of a date before or after a number of workdays by specifying which days are weekend days.
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?
To use the WORKDAY function, you need to specify the date you want to calculate, the number of workdays and which days are weekend days. You can then enter the formula into a cell and the WORKDAY function will return the date.

Related Functions

Sourcetable Logo

Work smarter

Al is here to help. Leverage the latest models to
analyze spreadsheets, enrich data, and create reports.

Drop CSV