Applying Formatting to Dates in LibreOffice Calc

[@lyndieharkey2566]

Thank you for your videos. My question is, is it possible to highlight a column of cells, and just have the system update the year? My cells are MM/DD/ and each year I copy business spread sheets and change all the data, but am generally entering data from a prior year, say it is 2024 and I need to enter data for 2023. Thanks in advance for any help.