next up previous contents index
Next: EFFECT Up: A. Function Reference Previous: DURATION   Contents   Index


EDATE

Syntax: EDATE(S, M)

S = Start date
M = Months

EDATE returns a date/time value representing the date M months after S if M is positive, and M months previous to S if M is negative. The date returned will be on the same day of the month as S.

Examples:

EDATE(DATEVALUE(``2/29/92''), 3) = 33753 or 05/29/92

EDATE(DATEVALUE(``2/29/92''), 12) = 34028 or 2/28/93

EDATE(DATEVALUE(``3/30/93''), -6) = 33877 or 09/30/92

Excel function: N/A


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