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

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


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

NExS User's Guide, Version 1.4.5
Grey Trout Software
11 April 1999