Excel + Google Sheets · WORKDAY

Get the deadline in working days

Adds working days to a date, skipping weekends.

The formula

=WORKDAY(B2, 10)

What each part means

B2Start date
10Working days to add

Example

Before

	A	B	C
1	Task	Start	Due
2	Design	Nov 2
3	Copy	Nov 4
4	Print	Nov 6

After

	A	B	C
1	Task	Start	Due
2	Design	Nov 2	Nov 16
3	Copy	Nov 4	Nov 18
4	Print	Nov 6	Nov 20

Step by step

Click cell C2.
Type the formula: =WORKDAY(B2, 10)
Press Enter.
Drag the small square in the bottom-right corner of the cell down to copy it to the other rows.

Where it works

Every version of Excel
Google Sheets
Excel for the web (free)

The same formula in other languages

English WORKDAY
Español DIA.LAB
Português DIATRABALHO

Get 1 formula a day, free

Plus a free weekly planner template for Excel and Google Sheets. Unsubscribe in 1 click.

✓ Done! Check your inbox to confirm.

Want ready-made templates? See the Formulyo pack →

Keep learning

NETWORKDAYSWorking days left to the deadline EOMONTHThe last day of any month, instantly DATEDIFExcel's hidden formula TEXTTurn any date into its weekday &Join cells with one symbol COUNTA + UNIQUECount unique values