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