Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
dateadd
In a macro I would like to add 1 month to a date in another cell. L5 =
3/31/07 so when the macro runs I would like L4 to display 4/30/07. something like: Range("L4").Select ActiveCell. add 1 month to date in L5. Any ideas?? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
dateadd
Answered in another post
-- Don Guillett SalesAid Software "The BriGuy" wrote in message ... In a macro I would like to add 1 month to a date in another cell. L5 = 3/31/07 so when the macro runs I would like L4 to display 4/30/07. something like: Range("L4").Select ActiveCell. add 1 month to date in L5. Any ideas?? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using DateAdd Function with cell values | Excel Discussion (Misc queries) |