How to Count Workdays Between Two Dates in Excel

Open your Excel ticket workbook (.xlsx) in Cue Office and use NETWORKDAYS to calculate business days between two dates. Saturdays, Sundays, and specified holidays are excluded, while valid start and end dates on regular workdays are counted.

Do start and end dates count as workdays?

In Cue Office, create a new spreadsheet and paste the practice data into A1. Columns B and C contain the start and end dates. G2 contains the shared holiday, 11/16/2026. If the dates display as number signs, select columns B, C, and G. On the Home tab, choose Format → Column Width… and enter 15.

Four support tickets with start and end dates, a holiday in G2, and blank result cells in columns D and H
Confirm the ticket start and end dates alongside the holiday in G2 before entering the workday formula.

Select D2 and paste the four formula rows below. The first two arguments represent the ticket start and end dates. The third argument, $G$2, locks the reference to the shared holiday across all four rows.

=NETWORKDAYS(B2,C2,$G$2)
=NETWORKDAYS(B3,C3,$G$2)
=NETWORKDAYS(B4,C4,$G$2)
=NETWORKDAYS(B5,C5,$G$2)

Ticket T101 starts on Friday, November 13, and ends on Tuesday, November 17. Counting Friday and Tuesday while skipping the weekend and Monday holiday yields 2. When start and end fall on the same day, T102 lands on a working day and returns 1. T103 falls on a Saturday and T104 on a holiday, so both return 0.

Formula with holiday reference selected in D2, complete ticket dates, and column D results showing 2, 1, 0, and 0
With Friday and Tuesday each counted as one day for T101, cell D2 shows 2.

Why does missing a holiday add an extra day?

Select H2 and paste these four formulas. They use the same start and end dates, so you can see how the count changes when you leave out the holiday.

=NETWORKDAYS(B2,C2)
=NETWORKDAYS(B3,C3)
=NETWORKDAYS(B4,C4)
=NETWORKDAYS(B5,C5)

T101 increases from 2 to 3 days, and T104 jumps from 0 to 1 day, because both now include November 16. Save and reopen the workbook, then compare columns D and H.

Formula in H2 containing only start and end dates, with column H showing results 3, 1, 0, and 1
The H2 formula omits the holiday, so the count includes Monday, November 16.

If only the first row deducted the holiday, click D3 and check the formula bar. Then click D4 and D5 one at a time and check the formula bar for each cell. The row numbers for B and C should adjust for each ticket, while the third argument must remain locked as $G$2.

How do you get Cue AI to use the same holiday on every row?

Open a copy of the ticket workbook with D2:D5 left blank, launch Cue AI, and state how to calculate the workdays and where to output the results.

Calculate the number of workdays for each support ticket using the start dates in B2:B5 and end dates in C2:C5. Exclude Saturdays, Sundays, and the holiday listed in G2. Count the start and end dates when they are workdays. Write the results only in D2:D5 and make them update when the dates or holiday change. Leave all source cells unchanged.

After the initial run, D2 referenced G2, but D3 through D5 referenced G3 through G5 respectively. If this happens, ask Cue AI to fix the references row by row within the same chat session.

The one shared holiday is in G2. Please correct the four workday results in D2:D5 so every row always reads holiday G2, including rows 3, 4, and 5. Do not use G3, G4, or G5, and write each result independently instead of filling down. Keep each ticket’s own start and end dates, count workday endpoints, exclude Saturdays and Sundays, and do not edit cells outside D2:D5.

After the correction, D2:D5 all reference $G$2. Save and reopen the workbook copy, verifying that all four ticket dates and headers remain intact, with workday counts showing 2, 1, 0, and 0.

Reopened AI workbook retaining four sets of ticket dates and the G2 holiday, with column D displaying 2, 1, 0, and 0
After restoring original dates and reopening, column D still displays 2, 1, 0, and 0.

You can change a date to see if the results update dynamically. Change G2 to 11/19/2026, and the four results update to 3, 1, 0, and 1. Keeping that holiday, extend C2 to 11/18/2026, and T101 will update from 3 days to 4 days.

Holiday in G2 updated to 11/19/2026 with formula in D5 still referencing G2 and workday results showing 3, 1, 0, and 1
With the holiday moved to November 19, T104 now counts as one workday. The D5 formula still points to G2.

Practice with four support tickets

Show the full example

Paste the following into cell A1, entering dates in Month/Day/Year format and confirming they are recognized as dates. Return to formula steps.

Ticket	Start	End	Workdays			Holiday	Without holiday
T101	11/13/2026	11/17/2026				11/16/2026
T102	11/17/2026	11/17/2026
T103	11/14/2026	11/14/2026
T104	11/16/2026	11/16/2026

Review holiday-spanning tickets before shift handover

When scheduling the next holiday coverage, provide Cue AI with the start and end date columns, the shared holiday, and the target output column to recalculate using the same logic. Pick one ticket resolved on the same day and another spanning a shutdown day, counting manually against a calendar to verify. If holiday schedules shift, double-check that every ticket still references the exact same holiday cell.

Open the PDF holiday notice (.pdf) for free in Cue Office and compare the date with G2 in your Excel workbook (.xlsx). If the holiday moves, log the old date, new date, and affected ticket IDs in a Word handover note (.docx). If you brief the next shift, use a PowerPoint deck (.pptx) to flag tickets whose workday counts changed. Cue Office offers free spreadsheet, document, and presentation editing.

Download Cue Office for Free