Automatically updated rolling 24 month period

This assumes you will need to make a change in both B3 and B4 before the macro triggers. Took a lot longer than I thought it would with the way you had it set up so I hope your real sheet mirrors your example

Please Login or Register  to view this content.

Hi stnkynts, thank you for your response. I must not be doing something correctly, I cannot get your code to work.

Woops. I forgot to publicly declare some variables. Try this:

Please Login or Register  to view this content.

Hi stnkynts, it works like a charm! The only thing that I forgot to mention is that I wanted the dates in B3 & B4 to be month 1 and for the months to go back in time. How hard is it to go back in months instead of forward? Please forgive me...