Embedded Files
Description
Description
PeriodsLabelsλ() translates dates to various intervals and formats them so they can be sorted in reports and pivots.
Syntax
Syntax
PeriodLabelλ(Date, [Interval], [Diagnostics])
Date (Required)
A single date or array of date(s) where the first date is the first date of a calendar year.
Interval (Optional)
Must be one of:
D Daily
W Weekly
I Weekly (using ISO week number)
M Monthly
Q Quarterly
S Semi-Annually
A or Y Annually
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
Example
In this example we see a timeline as it is normally presented and below it we see it presented with period labels.
Page updated
Google Sites
Report abuse