NxEDATE - Advance a date by a given period

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

  1. If the number in the period is negative,(e.g., -1 years, -3q, -5-month), NxEDATE calculate the date before the given period.
  2. If the given date is not valid, NxEDATE returns the #VALUE! error.
  3. If the Period description is not recognized (i.e. not currently supported), NxEDATE returns the #VALUE! error.
  4. 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

  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

Have more questions? Submit a request

0 Comments