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.
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.
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.
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.
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.
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.