Thread
:
dateadd
View Single Post
#
8
Posted to microsoft.public.excel.programming
Don Guillett
external usenet poster
Posts: 10,124
dateadd
"Didn't work" means nothing without explanation.
I fully tested. Shouldn't make any difference but you didn't post your code,
so???
mc = Range("l5")
Range("l4") = DateSerial(Year(mc), Month(mc) + 1, Day(mc))
--
Don Guillett
SalesAid Software
"The BriGuy" wrote in message
...
This didn't work either. I think because this is being put in the middle
of
a larger macro that was expected to end befor I entered Sub again?
"Don Guillett" wrote:
Sub addmonthtodate()' NO selections
mc = Range("l5")
Range("l4") = DateSerial(Year(mc), Month(mc) + 1, Day(mc))
End Sub
--
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 With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett