Adding one day to a date

Closed
tripped - Apr 1, 2015 at 05:15 PM
 tripped - Apr 1, 2015 at 09:14 PM
Hello,
I have a spreadsheet that i use for planning truck maintenace, I am trying to work out how to have 2 buttons that i can assign 2 macrows too, one to add one day to a date in a cel, and one the subtracts a day from the same cel. thiswill make it easier to change the date in the cel up or down with out having to click in the cel and changing it.



1 response

found it

Range("c3").Value = Range("c3").Value - 1

and

Range("c3").Value = Range("c3").Value + 1
0