=HOLIDAYS("IN",2026)
=HOLIDAYS("IN",2026)Returns the known date/name table, beginning 2026-01-26 · Republic Day.
Country guide · IN
India holidays and business days
Use "IN" for the India country-level calendar. The following coverage describes the pinned release 2026-09-15-holidays-0.104-t0-repair-5.
Weekend rule
Saturday–Sunday, using the Monday-to-Sunday mask 0000011 throughout 2000–2035 in this release. The optional weekend argument overrides the default; extra closures and public holidays still take precedence.
Coverage is statutory weekend only: this code has no source working-weekend data. We do not infer make-up working days or employer-specific schedules.
Subdivision support
States and union territories are available for holiday lists on Pro. Neither the national calendar nor any IN subdivision has a complete year under this pinned source. Pro does not remove that limitation.
36 subdivision entries. =SUBDIVISIONS("IN") lists the supported suffixes and names on either plan. Using a regional calendar requires Pro.
View all 36 subdivision codes
| Suffix | Name |
|---|---|
AN | Andaman and Nicobar Islands |
AP | Andhra Pradesh |
AR | Arunachal Pradesh |
AS | Assam |
BR | Bihar |
CG | Chhattisgarh |
CH | Chandigarh |
DH | Dadra and Nagar Haveli and Daman and Diu |
DL | Delhi |
GA | Goa |
GJ | Gujarat |
HP | Himachal Pradesh |
HR | Haryana |
JH | Jharkhand |
JK | Jammu and Kashmir |
KA | Karnataka |
KL | Kerala |
LA | Ladakh |
LD | Lakshadweep |
MH | Maharashtra |
ML | Meghalaya |
MN | Manipur |
MP | Madhya Pradesh |
MZ | Mizoram |
NL | Nagaland |
OD | Odisha |
PB | Punjab |
PY | Puducherry |
RJ | Rajasthan |
SK | Sikkim |
TN | Tamil Nadu |
TR | Tripura |
TS | Telangana |
UK | Uttarakhand |
UP | Uttar Pradesh |
WB | West Bengal |
Complete years and estimated dates
India has no complete year under the current data source. All national years in 2000–2035 are incomplete, and the same is true for its subdivisions. Business-day formulas return an explicit error; known holiday lists and names remain available.
First year with a source-labelled estimated date: 2000 (national calendar; every IN subdivision also starts at 2000). This is the first occurrence in the export, not a claim that only future dates are estimates.
Estimated dates can move by a day when authorities confirm them. Holiday names preserve the source’s " (estimated)" suffix where supplied; some source names suppress that label.
Worked examples
=ISWORKDAY("2026-01-05","IN")
=ISWORKDAY("2026-01-05","IN")#N/A Calendar for IN 2026 not yet published; HOLIDAYS() shows the confirmed dates — no optimistic business-day result is returned.
Free and Pro
Free: every formula for the current calendar year and the next one, in the spreadsheet’s timezone; country-level only, no subdivisions and no custom extra ranges. In 2026, that window is 2026–2027.
Pro: $29/year or $4/month; holiday lists: 2000–2035, subject to source coverage; business-day formulas: years with published calendars. Includes subdivisions, custom extra ranges, and priority data corrections. Compare plans and owner-based access.
Calendar coverage and estimated dates
Estimated dates can move by a day when authorities confirm them. HOLIDAYS and HOLIDAYNAME preserve the source’s exact " (estimated)" suffix where supplied. An absent label does not prove that a date is confirmed.
For codes without working-weekend data, coverage is statutory weekend only: public holidays and the configured weekend rule, with no inferred make-up working days. Business-day formulas require a complete calendar for every year touched; Pro does not unlock unpublished calendars. Read the data coverage guide.