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)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")=IsTradingDay("2025-12-26")=IsTradingDay(TODAY())=IsTradingDay(A1)=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.
Related Formulas
More MarketXLS Date Functions formulas you can use in the same worksheet:
Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONS
Get started today
▶
How does MarketXLS work?