next up previous contents index
Next: ERF Up: A. Function Reference Previous: EIGEN   Contents   Index


EOMONTH

Syntax: EOMONTH(S, M)

S = Start date, a date/time value
M = Months, an integer

Returns a date/time value representing the date M months after S, if M is positive, and M months before S, if M is negative. The date returned will be on the last day of the month.

Examples:

EOMONTH(DATEVALUE(``7/7/93''), -24)= 33450 or 7/31/91

EOMONTH(DATEVALUE(``4/15/94''), 2)= 34515 or 6/30/94

Excel function: N/A


next up previous contents index
Next: ERF Up: A. Function Reference Previous: EIGEN   Contents   Index
SpreadScript User's Guide, Version 1.2
Grey Trout Software
02 March 2003