LAMBDA: CreateStartDatesλ
Description
Returns a one dimensional array of dates to use in a timeline.
Nearly every financial model requires a timeline. Use this to create timelines by day, week, month, quarter or year.
Syntax
We see this LAMBDA being use in the GIF.:
=CreateStartDatesλ( <CalendarStart>, [<CalendarEnd>], [<Interval>] )
Where:
CalendarStart- is the timeline's first date.
CalendarEnd- (Optional) is the timeline's last date. The default is one year after the calendar start date.
Interval- (Optional) is a code indicating the period between dates. The default is days. The codes are:
Y=Years
Q=Quarters
M=Months
W=Weeks
D=Days
Importing
This is component can be imported from:
Use the Advance Formula Environment add-in available (free) from the Microsoft store. Click Advanced Formula Environment to learn more about that.
All of my LAMBDAs can be found here: https://gist.github.com/CHatmaker.