Formulas > =WORKDAY()
How to Use WORKDAY() in Google Sheets
Description
How To Actually Use WORKDAY() in Sheets
WORKDAY(start_date, num_days, [holidays])
Try WORKDAY yourself
In cell B1, use the WORKDAY formula to calculate the end date starting from the date in cell A1 and adding 10 working days. The result should be a valid date.
Hints (2)
-
Remember to reference the correct cell for the start date.
-
The second argument is the number of working days to add.
1 Better Sheets Tutorial
CRM Automations
Simple automations you can add you to your CRM to keep it clean and looking great.
DATEDIF()
IF()
ISBLANK()
WORKDAY()
Learn more about the WORKDAY() formula:
Generate a WORKDAY() formula for your needs
Describe your task in plain English and get a paste-ready formula that uses WORKDAY(). 2 free AI generations, no signup. Members get unlimited use.
Generate a WORKDAY() formula