Business Day and Holiday Calendar Formulas
Handle deadlines around weekends and holidays.
The Open buttons send the prompt text as currently shown below to that site only when you click. Fill in the placeholders first.
[VERIFY] is an editorial flag, not a blank to fill. Wherever the prompt shows [VERIFY], check that item against a reliable source before you use it.
Build a business-day calculator. App: [SPREADSHEET_APP]. Country, region, and weekend pattern: [LOCATION_AND_WEEKEND]. Holidays to include (provide the list or the rules): [HOLIDAY_LIST]. Calculations needed (due dates, service-level deadlines, lead times, shipping estimates): [CALCULATIONS_NEEDED]. Provide: 1. A holiday table with date, name, region, and year; instructions to maintain it each year and verify against official sources [VERIFY]. 2. Formulas: WORKDAY and WORKDAY.INTL (custom weekends such as Friday-Saturday), NETWORKDAYS and NETWORKDAYS.INTL, with the holiday list as a named range. 3. "Next business day" and "previous business day" formulas: =WORKDAY(date-1, 1, holidays) and =WORKDAY(date+1, -1, holidays). 4. SLA deadline calculation by hours within working hours (an approach using business days plus time within a workday), noting complexity and limits. 5. Business days in a month and remaining business days. 6. A shipping estimate: order date plus processing days plus transit days, skipping non-delivery days. 7. Region-specific lists and a selector. Add validation for date inputs, test cases (a deadline falling on a holiday, across a weekend, across year end) with expected results, and a warning that holiday dates change and local rules (observed holidays) vary. Don't invent holiday dates; ask me for the official list.
Fill in before use
Optional: type your details and the prompt above updates. Nothing is saved or sent.
Replace each bracketed placeholder with your own details, then paste into Any AI or another assistant.