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.

On-device・No uploadMobile friendlyWorks offline

Your files and input are processed only inside your browser on this device and are never uploaded to our servers.

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.

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.

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

Capability matrix

FeatureSupportNotes
Last business day, Nth business day, day of month (moved to previous/next business day), Nth weekday, quarter end, fiscal year end, weeklySupported—
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 listSupported—
Business days between two dates, N business days after (before)Supported—
Japan’s spring and autumn equinox days from 2028PartialCalculated in advance. The official gazette fixes them in February of the previous year
US bank and stock market holidaysPartialFederal holidays (days off for federal employees) are used. Banks and markets can differ
Holidays of other countriesNot supportedOnly countries whose lists can be checked against official sources are supported
Automatic updates when holidays change (a subscribed calendar)Not supportedThe .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 holidaysNot supportedAdd 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.

Date & Time Studio — Unix Timestamp & Time Zone Converter

Paste a Unix timestamp or almost any date string — the unit and format are detected automatically and shown in 15 formats and multiple time zones. DST gaps, month ends and Japanese era boundaries are handled precisely.

No upload

ICS/VCF Calendar & Contact Studio

Open ICS events (repeats, all-day, time zones) and VCF contacts in your browser, then convert them to CSV or Excel. You can also create an .ics that Google Calendar and iPhone accept, and a .vcf from a CSV.

No upload

Invoice, Quote & Delivery Note Maker

Make invoices, quotes and delivery notes for free and save them as A4 portrait PDF. The form has the items a qualified invoice needs (請求書 in the Japanese form). It mixes 10%, 8% (reduced rate) and tax-exempt lines, takes prices with or without tax, and rounds tax down, to nearest or up per rate. Everything is made in your browser; nothing is sent.

No upload

Smart Converter (timestamp, epoch, Base64 and more)

Paste a timestamp, epoch number, ISO 8601 date, Base64 string, UUID, IP address, color or JWT. The tool guesses the format, shows every possible reading most likely first, and converts the one you pick into dozens of other formats, all in your browser.

No upload

Encode / Decode Studio — Base64, URL, JWT & more

Paste %E3%81%82, an eyJ… token or any encoded string — the format is detected and decoded instantly. Errors say exactly which character is wrong and why, and nothing leaves your browser.

No upload

Markdown Studio — Live Editor & Preview

A split-view Markdown editor with instant GFM preview, a table formatter that aligns pipes, an automatic table of contents and HTML export. Output is always sanitized and external images load only when you allow them.

No upload

Last updated: