How to Calculate a Due Date in Excel with WORKDAY

Open an Excel workbook (.xlsx) in Cue Office and use WORKDAY to calculate due dates. For a positive number of days, start counting on the first working day after receipt. Skip Saturdays, Sundays, and closure dates. Try it with four community repair tickets.

Which day counts as the first working day after receipt?

Open the community repair station worksheet. Column B, Received, records when each item arrived. Column C, Days, records the promised number of working days. F2:F3 lists closure dates. The printer arrives Friday, June 11, 2027. Skip the weekend and the June 14 closure, and the printer is due June 15.

Four repair work orders with empty due dates in column D and two closure dates on the right
The original table lists closure dates separately on the right, reserving column D for due dates.

Enter the following formula in D2 and press Enter. $F$2:$F$3 locks the closure range so that when the formula is filled down, every row references the same list of closure dates.

=WORKDAY(B2,C2,$F$2:$F$3)
WORKDAY formula bar and serial date number 46553 in D2
Under the General format, D2 initially displays the serial date number 46553.

Select D2:D5 and choose Home → Fill → Fill Down. With those cells still selected, choose Short Date from the number format menu on Home. The date serial 46553 displays as a calendar date and remains available for calculations.

Short Date option in the Home number format menu
Change the number format of D2:D5 to Short Date.

What happens when the promised days or closure dates change?

The four due dates are June 15, June 16, June 10, and June 21, in row order. The radio arrives the same day as the printer, with one extra working day promised. The camera arrives on Friday, June 18, and is due on Monday. The lamp arrives on a regular working day, June 10. Its promised time is zero days, so in this example its due date is the day it arrived.

In a copy of the sheet, temporarily change the printer’s C2 to 2. Its due date moves to June 16.

Printer due date updates to June 16, 2027 after setting promised working days to 2
Changing the Printer to 2 working days updates the due date to June 16.

Restore C2 back to 1, then temporarily change F2 to June 28, 2027. June 14 becomes counted as a normal working day again, moving the Printer's due date up to June 14 and the Radio's to June 15.

Printer and Radio due dates shift to June 14 and June 15 after moving the June 14 closure
Changing F2 to June 28 restores June 14 as a working day.

Before testing these changes, use File → Save As… to preserve a copy with the original unedited inputs. After testing, close and reopen this saved copy to verify the four due dates against the original closure schedule. Selecting any result cell displays the underlying formula in the formula bar.

Four work order due dates upon manual reopening, with D4 still containing the WORKDAY formula
Reopening the manually saved copy confirms the four due dates match the original closure schedule.

How do you ask Cue AI to use the same closure dates?

Open a copy of the original table before the due dates are filled, and click Cue AI on the toolbar. Specify which day counting begins, which days to skip, and which four cells to populate.

Cue AI toolbar button and the open pane on the left
Open Cue AI from a copy of the original work order table.
When should each repair be due? Fill D2 through D5 from the Received and Days columns. Start counting on the first working day after receipt, skip Saturdays, Sundays, and the closure dates in F2 through F3, and use the received date when Days is zero. Use formulas and display the results as real dates. Keep the repair inputs, headings, and closure dates as they are.

Once populated, temporarily change F2 to June 28. The AI-generated due dates update dynamically as well, shifting the first two items earlier to June 14 and June 15. Undo this change after testing.

In the AI version, temporarily changing F2 to June 28 shifts the first two due dates earlier
The two due dates populated by AI also update dynamically with the closure schedule.

Use File → Save As… to save the AI copy, close it, and reopen it to verify the four due dates and original closure dates. Selecting D4 for the Lamp reveals that the formula includes a conditional branch handling 0 days by referencing the receipt date directly.

Four dates and D4 formula bar after reopening the AI-saved file
Reopening the AI copy shows the Lamp remains due on receipt, while the other three due dates match the manual results.

Practice with Four Repair Work Orders

Show the full example

Set up the example in A1:F5. Leave column E and D2:D5 empty. The example uses month/day/year. Enter the dates in columns B and F in a format your workbook recognizes so the formulas can use them. Return to the first formula.

Item	Received	Days	Due date		Closures
Printer	6/11/2027	1			6/14/2027
Radio	6/11/2027	2			6/25/2027
Lamp	6/10/2027	0
Camera	6/18/2027	1

Review Closures and Due Dates Together During Handover

When the repair station updates its closure dates, ask Cue AI to recalculate the due dates using the revised list. For example, if June 14 opens up, check that both the printer and radio are due earlier before you hand the tickets to the next shift. Add the lamp to the list of items due the day they arrive.

Use the Excel ticket log (.xlsx) in Cue Office to keep receipt dates, promised working days, and closures together. Check the latest closure notice (.pdf) and record high-priority repairs in the Word handover (.docx). Use a PowerPoint shift briefing (.pptx) to tell staff to handle the lamp first. Spreadsheets, documents, and presentations are free to edit, and PDFs are free to read.

Download Cue Office for Free