Excel FP&A Web Dev Blog

Loading...

Blake Ekelund

Finance ops, half-formed plans, fully-formed spreadsheets.

Work

Excel
FP&A
Web Dev
Blog

Off the clock

Play
On my mindsoon
Golfsoon
MN Sportssoon

Find me

Email
GitHub
LinkedIn

More

Search
Sitemap
Robots

© 2026 Blake Ekelund · Built with Excel, chocky milk, and too many tabs open.

Generate Date Range – Excel LAMBDA | Blake Ekelund

Excel Toolkit›Generate Date Range

Generate Date Range

AutomationIntermediate

Generates a vertical list of dates between two boundaries.

LAMBDA(start_date, end_date, SEQUENCE(end_date - start_date + 1, 1, start_date, 1) )

Parameters

start_date
end_date

Example Usage

=GENERATE_DATE_RANGE("2024-01-01","2024-01-10")

Pro Tips

Wrap in TEXT() for formatted output

Common Issues

Start date must be <= end date