Note: In order to use the spreadsheet examples, you need to download Business Functions
|NextDateSeq (TheDate, AnnDateSeq, [SpecificDates])|
|Next Date in the Sequence|
|Determines the next date after TheDate that will arise in the specified AnnDateSeq.|
|...Seq...||Using Date Sequence|
Whats good or unique about it
NextDateSeq is a great function for preparing the list of dates for a structured financing, particularly because it accepts a BusDaySwitch within the sequence and can therefore slip the date returned to the next business day. See the example for more details.
TemplatesThis function features in the following downloadable spreadsheet template(s):