Syntax

Periodsλ( PeriodEndDates , RateStartDates , Rates)

Starts
(Required) First date (normally older). This can be a single number or array.

Ends
(Required) Second date (normally newer). This must be the same shape (# of rows & columns) as Date1.

Interval
(Optional) Days, Weeks, Months (default), Quarters, or Years (D, W, M, Q, Y)

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.