Embedded Files
Description
Description
Timelineλ() creates a horizontal timeline of either start dates or end dates for various period intervals.
Syntax
Syntax
Timelineλ( StartDate, [Periods], [Interval], [PeriodStarts?])
StartDate (Required)
First period's start date. May be entered as text.
Periods (Optional)
The number of periods in the timeline. Defaults to 12.
Interval (Optional)
Period interval: D, W, M, Q or Y (Day, Week, Month <default>, Quarter, or Year)
PeriodStarts? (Optional)
TRUE=Display period start dates <default>. FALSE=Period end dates
Example
Example
This example creates the typical start and end period timelines for a financial model spanning 60 periods in months.
Timelineλ() defaults to one month periods.
Page updated
Google Sites
Report abuse