This isn’t so much of a question, more a possible solution. I was after adding a year to the date in a cell, to mark the end of annual subscriptions, so that 15/03/2012 would become 15/03/2013. What I came up with, courtesy of the function wizard was:
Where K2 is the cell coordinate in my sheet. In a date-formatted cell, of course. I thought this might be useful to some folks, and I’m also curious about a simpler solution, if one exists.
Kudos to whoever put the function wizard together, as that’s a big help to folk like myself whose spreadsheet skills are a bit rusty.