How to use the WORKDAY function
Author: Oscar Cronquist Article last updated on May 09, 2022
The WORKDAY function returns a date based on a start date and a given number of working days (nonweekend and nonholidays).
The start date is shown in the image above, 12 working days later is 1/17/2018.
Formula in cell B8:
=WORKDAY(C3,C4)
Excel Function Syntax
WORKDAY(start_date, days, [holidays])
Arguments
| start_date | Required. |
| days | Required. Positive integer returns a date after the start_date (future) and negative integer returns a date before the start_date. |
| [holidays] | Optional. A list of holiday dates. |
Comments
The WORKDAY function returns
- #VALUE! error value if start_date or [holidays] are not a valid date.
- #NUM error if start_date plus days argument returns an invalid date.
(Excel can't handle dates before 1/1/1900.)
Use the DATE function to create a date if you happen to enter the date in the function.
Example:
=WORKDAY(DATE(2018,1,1),C4)
Negative days argument and a holiday
Formula in cell B9:
=WORKDAY(C3,C4,C5)
'WORKDAY' function examples
The following article has a formula that contains the WORKDAY function.
How to track sector performance in the stock market – Excel template
The image above shows the performance across industry groups for different date ranges, conditional formatting makes the table much easier […]
The image above shows the performance across industry groups for different date ranges, conditional formatting makes the table much easier […]
Functions in 'Date and Time' category
The WORKDAY function function is one of many functions in the 'Date and Time' category.
How to comment
How to add a formula to your comment
<code>Insert your formula here.</code>
Convert less than and larger than signs
Use html character entities instead of less than and larger than signs.
< becomes < and > becomes >
How to add VBA code to your comment
[vb 1="vbnet" language=","]
Put your VBA code here.
[/vb]
How to add a picture to your comment:
Upload picture to postimage.org or imgur
Paste image link to your comment.
Contact Oscar
You can contact me through this contact form