Returns the serial number of the date after a given period (e.g. 1-week, 3-months, etc.)
Syntax
NxEDATE(Period, Date)
- Period
- is a description of a period range (e.g. "5-days", "1 month", "1m", "3 w", "-1 year").
Type Examples O/N O/N and ON (overnight) Day 1d, 2-D, -3 days, 5 day Week 1w, 2W, 3-w, -5 weeks, 1 week Month 1m, -3M, 5 months, -1 month Quarter 1q, 3-Q, 5Q, -3 Quarters, 1 quarter Year 7y, 7Y, 7 years, 7-Y, -1 year - Date
- is a serial number that represents the start date. If missing, the current date is used.
Remarks
- If the number in the period is negative,(e.g., -1 years, -3q, -5-month), NxEDATE calculate the date before the given period.
- If the given date is not valid, NxEDATE returns the #VALUE! error.
- If the Period description is not recognized (i.e. not currently supported), NxEDATE returns the #VALUE! error.
- Microsoft Excel stores dates as sequential serial numbers so they can be used in calculations. By default, January 1, 1900 is serial number 1, and January 1, 2008 is serial number 39448 because it is 39,448 days after January 1, 1900.
Examples
Example 1:
| Formula | Description (Result) |
|---|---|
| =NxEDATE("-3 years",DATE(2012,5,25)) | 2009-05-25 |
| =NxEDATE("1m",DATE(2012,5,25)) | 2012-06-25 |
| =NxEDATE("5-week",DATE(2012,5,25)) | 2012-06-29 |
| =NxEDATE("5 days",DATE(2012,5,25)) | 2012-05-30 |
Files Examples
References
- Hans-Peter Deutsch, Derivatives and Internal Models, Palgrave Macmillan (2002), ISBN 0333977068
Comments
Article is closed for comments.