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.)


NxEDATE(Period, Date)
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
is a serial number that represents the start date. If missing, the current date is used.


  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.


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



Article is closed for comments.

Was this article helpful?
0 out of 0 found this helpful