DpY function

Date and Time Calculations category - Date Increment family Home 
What the name means"Date Plus Years"
SyntaxDpY ( TheDate, Yrs, [DayCount], [Periods] )
DescriptionIncrements TheDate by the number of years specified in Yrs.
See AlsoDpM (TheDate, Months, [DayCount], [Periods])
VariableType or ValueDescription
Inputs: (4)
1 TheDate Date A date.
2 Yrs Float A number of years.
3 DayCount Float (Optional) Either a single number denoting the DayCount method, or a number in the form ww.ss where ww is the daycount of whole periods and ss applies to stub periods. See Using Daycount. (Optional)
4 Periods Annual Sequence (Optional) Either an option number, or a range of floats, describing the accruals periods or the timing of cash payments, in the format mm.dd for payments in advance or -mm.dd for payments in arrears. See Using Daycount (Optional)
Output:
Return Value DateResult Date The result of the function expressed as a date.
Defaults and Values

The variable(s) of this function have certain defaults and/or switch values associated with them. Click here to see more.

Features

This function has a few features that help explain its name. Click here to see more.

Whats good or unique about it
  • Although this gives results consistent with Excel's EDATE function for integer months and with DayCount omitted, this function also copes with all values for Yrs.
  • The function also copes with differing DayCount conventions.
Examples
  • Preview of the DpY example.
  • The above spreadsheet can be accessed from the Quick Reference (on the Business Functions menu), on the Examples menu, or in the Business Functions\Component Examples directory
Published Edition Changes in Behaviour

This function has experienced some changes in its behaviour over its history. Click here to see more.