reverse by one day

[raccoon588]

I have a cell with a date in it. I would like to have a button the user can click on to reverse the day by one day. so if the cell ready 7/26/17 then clicking the button will make the date 7/25/17 and then if you click the button again it will go back to 7/24/17, i am having no luck with this. can anyone help? thank you

 

[Roxxien]

Hello,

You should use this kind of formula as it will add minus 1 day. (reverse by one)

Range("A1")=Dateadd("d",-1,Range("A1"))

 

[raccoon588]

Thank you, this worked