=COUNTRIES()
=COUNTRIES()Spills two columns beginning AD · Andorra, AE · United Arab Emirates, AF · Afghanistan. Leave the destination cells empty.
Formula reference
COUNTRIES
List supported country codes and names.
Signature
COUNTRIES()Square brackets mark optional arguments; do not type the brackets in your formula.
Arguments
| Argument | Meaning |
|---|---|
| None | This function takes no arguments. |
Return value
Returns a 2-D list: country codes in column A and country names in column B. The pinned index contains 251 two-letter entries, including the source’s UK alias; use GB for the United Kingdom. Directory presence does not imply a complete business-day calendar.
Worked examples
=ROWS(COUNTRIES())
=ROWS(COUNTRIES())Returns 251 for the pinned release. This count describes directory entries, not the number of complete country calendars.
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.