Ask LibreOffice - RSS feedhttps://ask.libreoffice.org/en/questions/Questions and answers for LibreOfficeenMon, 13 May 2013 21:42:21 +0200Adding years to a datehttps://ask.libreoffice.org/en/question/17453/adding-years-to-a-date/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:
=DATE(YEAR(K2)+1,MONTH(K2),DAY(K2))
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. fredrileyMon, 13 May 2013 21:42:21 +0200https://ask.libreoffice.org/en/question/17453/