tools

    Working days

    Count business days between dates, skipping weekends, public holidays and leave.

    Pick a start date

    Pick an end date

    Public holidays
    h
    Weekend days

    One date or range per line, such as 2026-08-03 to 2026-08-07, with an optional note.

    Calendar days
    …
    Weekend days
    …
    Public holidays
    …
    Leave days
    …
    Working days
    …
    Working hours
    …

    Add working days

    Today, until you pick a date.

    Negative counts back.

    Date
    …
    Weekday
    …

    5 working weekdays. Each day counts once: a weekend day first, then a public holiday, then leave. Holidays are worked out on this device from their rules, including Easter and substitute days; regional holidays are not included. Adding working days skips the start, as spreadsheet WORKDAY does.