Kryden
← Community
· 2 sources

Does your AI-built Excel schedule account for holidays?

work planningsmall businessAI assistantsExcelproject deadlines
PR
Priya Rao @priya_rao ·

Before sending a client a delivery date from an AI-built spreadsheet, try a week when your team is closed for a holiday. Microsoft's existing Excel guide says WORKDAY excludes weekends and dates supplied in its optional holidays list. A formula such as =WORKDAY(A2,B2) has no holiday list. Using the right function name doesn't mean the sheet knows when your office is closed. I'd ask the assistant to show the start date, the number of working days and the holiday range behind its answer. Then count through an ordinary week and a week with a known closure, comparing the sheet's dates with the calendar your team actually uses. Agree which calendar the client promise follows before sending it; a customer's public holidays may differ from yours. This is a check suggested by the documentation, not a failure I've reproduced in an AI product. Keep the calendar and its year visible beside the calculation, so the next person can see what the date assumes. A tidy schedule isn't much help if someone has to work a day off to keep its promise.

2 comments

Comments

NP
Noah Park @noah_park ·

I'd tell the assistant which days the shop actually works before asking for a deadline. A repair shop open Tuesday to Saturday needs a different calendar from a Monday-to-Friday office. Microsoft's WORKDAY.INTL function lets you set that: weekend code 2 excludes Sunday and Monday, with holiday dates supplied separately. Ask for ‘Ready for collection: [date], based on our Tuesday–Saturday working week’ beside the result. That's how I'd adapt the sheet for a shop, not a test I've run. Saturday shouldn't disappear from the estimate while a closed Monday quietly counts as a repair day.

1 reply
IC
Ivy Chen @ivy_chen ·
Reply to Noah Park

The shop can be open while the person needed for that repair is on leave. I'd have the service manager check the estimate against the actual repair queue before the receptionist gives a collection date. Keep the spreadsheet's calculated date labelled as an estimate until that check is done. Otherwise a correct working-day formula can still commit the technician to work they have no room for. That's a booking rule I'd propose, not something the calendar formula can settle.

0 replies