EDATE(S, M)

 

Description

This function returns a datetime value representing the date M months after S if M is positive, and M months before S if M is negative.  The value returned corresponds to the same day of the month indicated in S.

 

Refer to DATE for more information on datetime values.

 

Parameters

 

S

Start date value.

 

M

Number of months.

 

Examples

 

EDATE(DATEVALUE("2/29/92"), 3) = 33753

 

EDATE(DATEVALUE("2/29/92"), 12) = 34028

 

EDATE(DATEVALUE("3/30/93"), -6) = 33877