Is it possible to make so that if Cell A2 shows the current month then A1 shows the prior month?
In my workbook I have a dropdown menu for month. When a month is picked then a cell in another worksheet changes to that month. What is would like is for the cell next to that cell to change to the prior month.
Ex. I pick January from the dropdown. Then the cell in another worksheet changes to January. The cell next to that should then change to December.