Macro to cycle through dates

[Mile029]

I want a couple of buttons on my spreadsheet that moves a date forward or back. So I have a date in cell B3, I have two arrows that I want to assign a macro to. The up arrow would move the date in cell B3 up one day and down arrow would move the date in cell B3 back on date.

For example:
Date in B3 is 06/25/2023

If I click the up arrow, the date in cell B3 goes to 06/26/2023
If I click the down arrow, the date in cell B3 goes to 06/24/2023

The date in the cell is actually pulling data from another sheet based on a lookup, so I want to cycle through the dates on the other sheet. So my lookup looks at the date and then pulls data into other cells on the same sheet based on that date. If anything can I cycle through the column on the other sheet that contains the dates?

What's the best way to do this? Thanks.

[kvsrinivasamurthy]

Pl see yellow banner on top of this page.

[jolivanes]

Like so?
2 Small Buttons, one with a + and the other with a -

Please Login or Register  to view this content.

Please Login or Register  to view this content.

[Mile029]

Awsome, thanks Jolivanes, that works perfectly!

[alansidman]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

Also, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.

[Mile029]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

Also, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.

I did both, thanks!

[jolivanes]

Thanks for that and good luck.