I have a row of dates that I need two "results" for.
The first result is meant to be a direct change of year only; the second would be to get the relative - ie recognize that 21 March 2016 is the third Monday in March and change it to the 3rd Monday in March for whichever year in the prompt box?
How could I cobble together a macro to:
- give me a prompt box to insert the new year value
- overwrite the old year with the new year from the prompt box
- go as far down as is required?