# Business Day Calendar (last business day, Nth business day)

Google Calendar cannot repeat “the last business day of the month”, “the 3rd business day” or “the 25th, or the previous business day if it is a day off”. This tool calculates them without holidays and company closures, then saves an .ics or CSV you can import. Everything runs in your browser.

- URL: https://tools.itlibra.com/en/business-day-calendar
- On-device・No upload
- Last updated: 2026-11-17

## How to use

1. Pick cards in “Rules”: payday, payment due, billing cut-off, month-end close, last business day and more (you can pick several). Change the country or region under “Business days”.
2. Edit the titles and notes, and the rule itself if needed (for example the 25th of each month, or the previous business day if it is a day off). You can add days off of the week and company closures such as year-end or summer holidays.
3. Choose the period (start month and number of months, up to 60). The calendar and list appear on the right, with the reason for each moved date, such as “Wed 29 Apr is a day off (Showa Day), so moved to the previous business day”.
4. Press “Save .ics” and import it into Google Calendar, Outlook or iPhone. A CSV for the Google Calendar import and a copy of the list are also available.
5. When holidays change, open the tool again, rebuild the file and import it again. The rules are kept in the URL, so you can bookmark or share the same settings.

## Use cases

- Accounting: put the monthly billing cut-off, payment due date and month-end close (3rd business day) on the calendar without holidays
- Admin and HR: share the payday (the 25th, or the previous business day) and the business days without year-end and summer closures
- Count business days between two dates, or find the date N business days after (or before) a deadline
- Teams in Japan, the US and the UK: make month-end events that skip each region’s public holidays
- Build the calendar from your own business days, including company closures, instead of importing a holiday calendar

## What it does

### Rules that skip holidays

Last business day, Nth business day (up to 23), N business days before the last one, a day of the month, the Nth weekday, quarter end and fiscal year end, or every week on a weekday. A day off can move to the previous or next business day, or stay.

### Japan, US and UK holidays

Japan uses the Cabinet Office list (through 2027) and the statute rules (substitute holidays, citizens’ holidays). The US uses federal holidays (matching OPM’s published lists). The UK uses GOV.UK bank holidays for England and Wales, Scotland and Northern Ireland.

### See why a date moved

Each row shows the original date, why it was a day off (holiday name, company closure, weekday), which way it moved and whether it crossed into another month. Months with no match and rules that landed on the same day are listed too.

### Month-by-month calendar

Event days, public holidays, company closures and holidays not yet officially fixed are marked with both colour and symbols. It fits a phone screen without sideways scrolling.

### .ics and Google Calendar CSV

Save all-day events (or timed events with a length) with an optional reminder. Event IDs come from the rule and the date, so rebuilding and importing again is less likely to create duplicates.

### Business days between and N days after

With the same business-day definition, count the business days between two dates (with a breakdown of days off) or find the date N business days after or before.


## Capability matrix

| Feature | Support | Notes |
| --- | --- | --- |
| Last business day, Nth business day, day of month (moved to previous/next business day), Nth weekday, quarter end, fiscal year end, weekly | Supported | — |
| Skip public holidays of Japan, the US (federal) and the UK (3 regions) | Supported | — |
| Days off of the week and company closures (dates, ranges, year-end) | Supported | — |
| Save .ics and Google Calendar CSV, copy the list | Supported | — |
| Business days between two dates, N business days after (before) | Supported | — |
| Japan’s spring and autumn equinox days from 2028 | Partial | Calculated in advance. The official gazette fixes them in February of the previous year |
| US bank and stock market holidays | Partial | Federal holidays (days off for federal employees) are used. Banks and markets can differ |
| Holidays of other countries | Not supported | Only countries whose lists can be checked against official sources are supported |
| Automatic updates when holidays change (a subscribed calendar) | Not supported | The .ics is an import. Nothing is sent over the network, so rebuild and import again when holidays change |
| Industry-specific closures, half days, regional Japanese holidays | Not supported | Add them as company closures |

## Limits & notes

- Up to 10 rules, 50 company closures added in the screen, 60 months, and 5000 events per saved file.
- Holidays are available from 1955 (Japan), 1971 (US) and 2019 (UK), through 2099. A period outside that range gives an error.
- Published official lists cover Japan through 2027 (Cabinet Office), the US through 2030 (OPM) and the UK through 2028 (GOV.UK). Later years are calculated from the statutes and usual rules and are marked “not yet confirmed”.
- The .ics is a snapshot at import time. When holidays or closures change, rebuild it and import it again (delete the old events in your calendar).
- Timed events are saved at the chosen time in the chosen time zone (zones with daylight saving time can be chosen).
- To type events one by one into an .ics, or to open an .ics and check it, use the ICS/VCF calendar & contact studio; for plain date and time maths, use the date & time converter.

## Privacy & safety

Calculation, display and file creation all happen in your browser. Rules and events are not sent or stored on a server. The URL holds only the rules and the period; titles, notes and closure names are never put in it. Usage statistics contain counts only.

## FAQ

### How do I add the last business day of every month to Google Calendar?

Google Calendar can repeat “the last Friday of the month” but not the last business day with holidays removed. Choose “Last business day” here, save the .ics and import it from Settings → Import & export. The events land on the dates that skip holidays and your company closures.

### How do I move a payday to the previous business day when it falls on a day off?

Pick the “Payday” card (the 25th, previous business day if it is a day off). When the 25th is a weekend or a holiday, the event moves to the business day before it, and the list says why, such as “Sat 25 Apr is a day off (Saturday), so moved to the previous business day”. You can change the day and the direction in the rule details.

### What is the 3rd business day, and how is it counted?

It is the third business day counted from the start of the month. Weekends, public holidays and company closures are not counted. If the 1st is a Friday, the days are the 1st, then the following Monday and Tuesday. It is often used as a target for the month-end close.

### Does the .ics update when holidays change?

No. It is an import with the dates calculated from the holidays known when you saved it. Japan’s equinox days are fixed in February of the previous year, and the screen warns when a period includes unconfirmed years. Rebuild and import again when something changes.

### Are US holidays the same as bank holidays?

The US option uses federal holidays (days off for federal employees). Banks and stock markets can differ, so add any extra days as company closures.

### Can I import the file into Outlook or an iPhone?

Yes. The saved .ics can be imported into Outlook (calendar import) and opened on an iPhone from Mail or the Files app. The steps are in “How to import” on the screen.
