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)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.
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?