EOMONTH(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 date returned is the last day of the month.

 

Refer to DATE for more information on datetime values.

 

Parameters

 

S

Start date value.

 

M

Number of months.

 

Examples

 

EOMONTH(DATEVALUE("7/7/93"), -24)= 33450

Which corresponds to 7/31/9.

 

EOMONTH(DATEVALUE("4/15/94"), 2)= 34515

Which corresponds to 6/30/94.