Trading Days
Returns a list of all US stock market trading dates between a start and end date. The result spills into cells below the formula, one date per row.
Return Value
The formula cell displays "Trading Days: {start} to {end}". A single-column table of dates spills below.
Spill Behavior
?? This function writes data to multiple cells. Ensure there is enough empty space below the formula cell.
Notes
- Only covers US equity markets (NYSE/NASDAQ)
- Excludes weekends and all NYSE-observed holidays
- Useful for calculating the number of trading days: count the spilled rows
- A confirmation dialog appears before overwriting existing cell data
Syntax
=TradingDays(StartDate, EndDate)Examples
=TradingDays("2025-01-01","2025-12-31")=TradingDays("2026-01-01","2026-03-31")=TradingDays(A1, B1)=TradingDays(DATE(2025,12,1), DATE(2025,12,31))When to Use
- Building trading calendars in Excel
- Counting the number of trading days in a period
- Identifying valid dates for historical price queries
- Calculating annualized returns (need trading day count)
When NOT to Use
\
Common Issues & FAQ
I'm getting a #SPILL error.?
The cells below the formula contain data. Clear the area to allow the date list to spill.
The function shows "Cancelled".?
You clicked "Cancel" on the overwrite warning dialog.
Can I count the number of trading days?
Yes — after the list spills, use COUNTA() on the spilled range to count trading days.
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?