Todays date plus 3 months & less 3 months

L

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
 
D

dolivastro

Use DateAdd, like this:

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

HTH,
Dom
 
G

Guest

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Saving a file with todays date on the end 6
How to copy one column values to another column based on conditionthat row2 contain todays date 4
Todays date minus 1 4
Converting dates to years, months & days 1
Select last months file 16
Date file created 7
Todays Date + 3months 3
Return to todays date macro 4

Top