JRoll

Use this function, in conjunction with the By function, to calculate a regular series of calendar dates rolled from a start date in a regular frequency.

JROLL (SymName|"StartDate", NumDays, SkipWeekends[,"Format"])        

where:

• SymName is TIMEPER symbol from which the range is to be calculated.
• StartDate is the first date in the range from which all other dates are counted forward. The format is “MM/dd/yyyy”.
• NumDays is the number of days between dates in the range to be generated.
• SkipWeekends designates that range dates falling on days of the weekend should be included in or excluded from the results and can be one of the following:

  Value	Description
  0	Designates that range dates falling on days of the weekend should be included in the results.
  1	Designates that range dates falling on days of the weekend should be excluded from the results.

• Format is optional and is the format of the date to be returned. The default is “yyyy-MM-dd hh:mm:ss”.

JROLL ("2010-04-05", 5, SkipWeekend)            

See also

• By