Get name of holiday ★
Returns the name of the holiday.
Returns a blank if there is no holiday.
URL
https://api.excelapi.org/datetime/holiday
Configuration
| Configuration | Required | Description |
|---|---|---|
| date | ✔ | Specify in Excel date serial values or yyyy/mm/dd format. |
| country | Specify the country code. If not specified, the default is JP (Japan). |
Example
=WEBSERVICE("https://api.excelapi.org/datetime/holiday?date="&A2)
info
The holidays in the Excel date range January 1, 1900 - December 31, 9999 are supported.