Updating the Year

SharonY

Hello,

I have a schedule created for 2024 and would like to update all the dates to 2025. I tried using find/replace and the values */24 with */25, but it I received a message saying no matches found. What else can i do? Any tips are appreciated.

Paul Newcome

Find/Replace doesn't allow wild-cards. If you were to try to just replace 25 with 25, you would also replace any dates that happened to be on the 24th of a month.

The most reliable way to do this would be to insert a temporary date type column, use a formula to output a date with the next year, copy the temp column data, and use "paste special" to paste the new date values into the original date column. From there you would be able to delete the temporary column and have all of your dates set for 1 year later.

=IFERROR(DATE(YEAR([Original Date Column]@row) + 1, MONTH([Original Date Column]@row), DAY([Original Date Column]@row)), "")