5g: Timelineλ()

Description

Timelineλ() creates a horizontal timeline of either start dates or end dates for various period intervals.

Syntax

Timelineλ( StartDate, [Periods], [Interval], [PeriodStarts?], [Diagnostics])

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

Diagnostics (Optional)
If TRUE, input errors that can occur after formula entry will display as diagnostic messages. The default is FALSE. It is recommended that models have a named range called Diagnostics and this named range be set to TRUE during model development and then set to FALSE when the model is placed into production.

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.