Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 *** |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 *** |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 *** |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 *** |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 *** |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculating months with half months. | Excel Discussion (Misc queries) | |||
3 months prior and 3 months post a date | Excel Worksheet Functions | |||
Adding months to dates should account for 28-30-31 day months | Excel Worksheet Functions | |||
How do i change 15 months to read 1 year and 3 months? | Excel Discussion (Misc queries) | |||
Dates to months and calculating values for their months | Excel Programming |