PDA

View Full Version : [SOLVED:] Need Macro To Change And Add So Many Days To A Cell With A Date



Granoldad
11-24-2016, 07:56 PM
Need Help Please!
Cell A1 = 11/20/16 I need to add a macro and assign it to a button to add 7 days to A1 each time the button is pressed.
I understand how to add the button and assign a macro to it; all I need is the macro that will change A1 from 11/20/16 to 11/27/16 and so on each time the button is pressed.

jolivanes
11-24-2016, 09:26 PM
Maybe
Sub Maybe()
Range("A1").Value = Range("A1").Value + 7
End Sub

Granoldad
11-24-2016, 10:53 PM
Maybe
Sub Maybe()
Range("A1").Value = Range("A1").Value + 7
End Sub

Thanks jolivanes

jolivanes
11-24-2016, 11:31 PM
You're welcome.