Determine holiday exists
Respond to the results as follows.
holiday: 1
NOT holiday: 0
URL
http://api.excelapi.org/datetime/isholiday
Configuration
Configuration | Required | Description |
---|---|---|
date | ✔ | Specify in Excel date serial values. |
country | Specify the country code. If not specified, the default is JP (Japan). |
Example
=WEBSERVICE("http://api.excelapi.org/datetime/isholiday?date="&A2)