Todays date plus 3 months & less 3 months

[Les Stout]

Hi, i can get todays date but need to add 3 months to it and the other
way too.

Any help would be much appreciated.

Les Stout

*** Sent via Developersdex http://www.developersdex.com ***

 

[JLGWhiz]

=TODAY()+90 ' (= 1/30/2007)
=TODAY()-90 ' (=8/3/2006 )

 

[dolivastro]

Use DateAdd, like this:

DateAdd ("m", 3, now())
DateAdd("m", -3, now())

HTH,
Dom

 

[JLGWhiz]

Also see "Add Dates" in Excel Help.

 

[Jim Jackson]

This will give an exact 3 month period.

IntervalType = "m"
Number = 3

ActiveSheet.Range("E17") = _
DateAdd(IntervalType, Number + 3, Range("E10"))
ActiveSheet.Range("E18") = _
DateAdd(IntervalType, Number - 3, Range("E10"))