Todays date plus 3 months & less 3 months
 

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 ***

Todays date plus 3 months & less 3 months
 

=TODAY()+90 ' (= 1/30/2007)
=TODAY()-90 ' (=8/3/2006 )
"Les Stout" wrote:

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 ***

Todays date plus 3 months & less 3 months
 

Use DateAdd, like this:

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

HTH,
Dom



Les Stout wrote:
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 ***

Todays date plus 3 months & less 3 months
 

Also see "Add Dates" in Excel Help.

"Les Stout" wrote:

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 ***

Todays date plus 3 months & less 3 months
 

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"))

--
Best wishes,

Jim


"Les Stout" wrote:

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 ***