| 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
=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 *** |
|
#3
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 *** |
|
#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 | |||
![Les Stout[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
