Is Trading Day

Checks whether the US stock market (NYSE/NASDAQ) is or was open for regular trading on a specific date. Returns TRUE for trading days and FALSE for weekends and market holidays.

Return Value

  • TRUE — the market is/was open on this date
  • FALSE — the market is/was closed (weekend or holiday)

US Market Holidays

The function accounts for all NYSE-observed holidays:

  • New Year's Day
  • Martin Luther King Jr. Day
  • Presidents' Day
  • Good Friday
  • Memorial Day
  • Juneteenth
  • Independence Day
  • Labor Day
  • Thanksgiving Day
  • Christmas Day

Notes

  • Only covers US equity markets (NYSE/NASDAQ)
  • Does not account for early close days (e.g., day before Thanksgiving)
  • Works for both past and future dates

Syntax

=IsTradingDay(OnDate)
Excel Desktop (Windows)

Parameters

OnDatedateRequired

The date to check (Excel date or date string)

Returns

boolean

TRUE if the US stock market was/is open on the given date, FALSE if closed (weekend, holiday)

Examples

=IsTradingDay("2025-12-25")
FALSE (Christmas)
=IsTradingDay("2025-12-26")
TRUE (Friday after Christmas)
=IsTradingDay(TODAY())
Is today a trading day?
=IsTradingDay(A1)
Check date from cell reference
=IF(IsTradingDay(TODAY()),"Market Open","Market Closed")

When to Use

  • Validating dates before running price queries
  • Building trading calendars in Excel
  • Conditional logic: only run calculations on trading days
  • Checking if a holiday falls on a market day

When NOT to Use

\

Common Issues & FAQ

I'm passing a date but getting an error.?

Make sure the cell is formatted as a date, or pass a string like "2025-12-25". Excel must recognize the value as a date.

Does this cover early close days?

No. Days with shortened hours (e.g., day before Thanksgiving, Christmas Eve) return TRUE because the market is still open.

Market data in your Excel sheets

1 billion usable data points on stocks, options, ETFs, and fundamentals, with simple Excel formulas.

See plans
MarketXLS Excel Add-in Tutorial - How to Use Is Trading Day and Other Financial Formulas
▶
How does MarketXLS work?