Excel + Google Sheets · NETWORKDAYS

Working days left to the deadline

Counts working days between two dates, skipping weekends (and holidays if you add them).

The formula

=NETWORKDAYS(TODAY(), B2)

What each part means

TODAY()From today
B2To the deadline

Example

TODAY: NOV 2

Before

	A	B	C
1	Project	Deadline	Days left
2	Launch	Nov 27
3	Report	Nov 13
4	Audit	Dec 11

After

	A	B	C
1	Project	Deadline	Days left
2	Launch	Nov 27	20
3	Report	Nov 13	10
4	Audit	Dec 11	30

Step by step

Click cell C2.
Type the formula: =NETWORKDAYS(TODAY(), B2)
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 NETWORKDAYS
Español DIAS.LAB
Português DIATRABALHOTOTAL

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

WORKDAYGet the deadline in working days EOMONTHThe last day of any month, instantly DATEDIFExcel's hidden formula TEXTTurn any date into its weekday ISNUMBER + SEARCHCheck if a cell contains a word XLOOKUP (2 criteria)XLOOKUP with two conditions