COPILOT CHAT AND EXCEL — SERVICE DESK QUEUE
Answer key for the supplied workbook. Open after you have tried the lab.

Use the timestamp in Queue!B3: 2 November 2026 at 12:00 UTC. Count only
Open tickets with a numeric deadline strictly earlier than the snapshot.

Baseline — 20 tickets, 3 overdue
IT-1003  VPN profile refresh     2 Nov 2026 09:30 UTC
IT-1011  Mailbox sync repair     1 Nov 2026 16:45 UTC
IT-1018  Print queue recovery   2 Nov 2026 11:59 UTC

Boundary checks
IT-1007 is open and due at exactly 12:00. It is not overdue at the snapshot.
IT-1006 is open and due at 12:01. It is not yet overdue.
IT-1018 and IT-1019 have the same 11:59 deadline. Only IT-1018 is open.
IT-1014 has no deadline. Keep it separate from overdue work.

Append this record INSIDE the Tickets table
IT-1021 | Wi-Fi certificate renewal | Open | 2 Nov 2026 11:30 UTC
With 21 records, the same three IDs plus IT-1021 should appear, for a total of 4.

Independent reference formulas (English Excel syntax)
The live chat supplied SUMPRODUCT for the count. COUNTIFS below is an alternative.
Total on a separate Report sheet:
=COUNTIFS(Tickets[Status],"Open",Tickets[DueUTC],">0",Tickets[DueUTC],"<"&Queue!$B$3)
IDs in a separate spreadsheet cell, outside an Excel table:
=FILTER(Tickets[TicketID],(Tickets[Status]="Open")*ISNUMBER(Tickets[DueUTC])*(Tickets[DueUTC]<Queue!$B$3),"None overdue")
Localized Excel may display translated function names and different separators.

An independent check: in a fresh starter copy, filter Status to Open and DueUTC
to values before the snapshot; exclude blanks explicitly. Alternatively, use
an extra column with =AND(C7="Open",ISNUMBER(D7),D7<$B$3) in the first data row,
fill down and filter to TRUE. Compare the visible IDs, not just their count.

These are expected results calculated from synthetic source data. Record what
your own Copilot run produces, including any correction you have to make.