Days Between Two Dates
days_betweenRead-onlyIdempotent
Count the days between two dates: total days (optionally including the start day), weeks and days, years/months/days, Japanese business days (excluding weekends and Japanese national holidays from the Cabinet Office list) and weekdays (Mon-Fri). Exact calendar arithmetic, no time zones. Dates 1873-01-01 to 2200-12-31.
Input Schema
TableJSON Schema
| Name | Required | Description | Default |
|---|---|---|---|
| lang | No | Language of the user. Use "ja" when the user writes in Japanese (affects the source link and notes). Default "en". | |
| end_date | Yes | Date in YYYY-MM-DD (1873-01-01 to 2200-12-31) | |
| start_date | Yes | Date in YYYY-MM-DD (1873-01-01 to 2200-12-31) | |
| include_start_day | No | Count the start day too (e.g. 2026-01-01 to 2026-01-01 = 1 day). Default false. |