=SUBDIVISIONS("GB")
=SUBDIVISIONS("GB")Returns ENG · England, NIR · Northern Ireland, SCT · Scotland, and WLS · Wales.
Formula reference
SUBDIVISIONS
Find region codes for a country.
Signature
SUBDIVISIONS(country)Square brackets mark optional arguments; do not type the brackets in your formula.
Arguments
| Argument | Meaning |
|---|---|
country | Required. Case-insensitive ISO-3166-1 alpha-2 country code, such as "US". Use COUNTRIES() for the supported directory. |
Return value
Returns a 2-D list of subdivision suffixes and names. Use a suffix from column A as the subdivision argument in another formula. A supported country with no subdivisions returns an empty result. Browsing this directory is available on Free; using a regional calendar requires Pro.
Worked examples
=SUBDIVISIONS("DE")
=SUBDIVISIONS("DE")Returns the German region directory, including BY · Bayern and BE · Berlin. Use "BY" as the subdivision argument for Bavaria.
=SUBDIVISIONS("IL")
=SUBDIVISIONS("IL")Returns an empty result: the pinned source exposes no subdivisions for Israel.
Free and Pro
This directory or diagnostic function is available on both Free and Pro, with no year argument. Regional calendar calculations, years outside the current + next calendar year, and custom extra ranges require Pro. The spreadsheet owner’s tier applies. See pricing.
Errors
Year-window, missing-year and incomplete-calendar errors do not apply to this directory or diagnostic call. SUBDIVISIONS with an unsupported country returns the unknown-code error below. These are the exact calendar error texts you may see in related formulas:
#N/A Unknown code XX; see COUNTRIES()— replace XX with the requested code.#N/A No holiday data for XX in 2036— a calculation touched a year with no data. Missing data is never treated as “no holidays”.#N/A Year 2028 needs Holiday Formulas Pro (holidayformulas.com/pro)— example for a Free user in 2026. The year in the message is the requested out-of-window year. View Pro.
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.