| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Adding months to a Date in VBA
I need to add months to a date. For example, 4/2/04 + 6 months to give
10/2/04. I have seen examples of how to add months such as: =MIN(DATE(YEAR(A1),MONTH(A1)+48,DAY(A1));DATE(YEAR (A1),MONTH(A1)+1+48,0)) But Date() means something different in VBA than in Excel. Is there another solution? Thanks. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Adding months to date at end of month | Excel Discussion (Misc queries) | |||
| Adding .45 months to a date | Excel Worksheet Functions | |||
| Adding months to a date | Excel Worksheet Functions | |||
| Adding 6 Months to a Date | Excel Worksheet Functions | |||
| Adding 6 months to any given date | New Users to Excel | |||
Threaded Mode
