EDATE function

  • 21 December 2021
  • 0 replies
  • 150 views

Userlevel 3
Badge

 

Description

Add or substract the given number of months to a given date

Note: if the day does not exist in the target month, the last day of the month will be used

 

Syntax

EDATE(date, monthOffset)

 

Return type

Date

 

Examples

Case

Results

Return Type

EDATE(DATE(2020, 12, 02), 2)

2021/02/02

Date

EDATE(DATE(2020, 12, 30), 2)

2021/02/28 (last day of February is used)

Date

 


Excel equivalent: EDATE(start_date, months)

See also: DATE


0 replies

Be the first to reply!

Reply