DATE.MONTH function

Category:Date and time

Name in English:EDATE

That makes?

Gets the serial number of a date that is one or more months after or before the specified date.

Syntax

DATE.MONTH (start_date, months)

  • start_date (required ): The start date where the account will start.
  • months (required ): The number of months to add or subtract from the start_date.

Examples

DATE.MONTH (“ 02/12/2011 ”, 2) = 40645 representing 04/12/2011
MONTH DATE (“ 02/12/2011 ”, -1) = 40555 representing 01/12/2011

Leave a Comment