Syntax
=WORKDAY(start_date, days, [holidays])Arguments
| Argument | Required | Description |
|---|---|---|
start_date | Required | The starting date |
days | Required | Working days to add (negative to go back) |
holidays | Optional | Optional dates to skip |
How to use WORKDAY
WORKDAY takes 2 required arguments and 1 optional argument. Type =WORKDAY( in a cell and SheetsBat shows the arguments as you go. Optional arguments are shown in square brackets; leave them out to use their default.
Examples
Each result below was calculated by the SheetsBat formula engine.
=WORKDAY(DATE(2008,10,1), 151)Result =WORKDAY(DATE(2008,10,1), 151, A1:A3)Result Data in the sheet
| A | |
|---|---|
| 1 | 39778 |
| 2 | 39786 |
| 3 | 39834 |
Related date and time functions
- SECONDReturns the second (0 to 59) of a time.
- TIMEBuilds a time of day from hours, minutes and seconds.
- TIMEVALUEConverts a time written as text into a fraction of a day.
- TODAYReturns the current date.
- WEEKDAYReturns the day of the week of a date as a number (by default 1 for Sunday to 7 for Saturday).
- WEEKNUMReturns the week number of a date in its year (the week containing January 1 is week 1).
- WORKDAY.INTLReturns the date a number of working days before or after a date, with a choice of weekend days and holidays.
- YEARReturns the year of a date.
- YEARFRACReturns the fraction of a year between two dates using a day count basis.