is it possible for me to enter a month and year in one row and have vba auto calculate the last 12 months back?

example:

October 11

have it show on the row above that the previous month and year?