Forum Discussion
Tina_Edwards
Sep 28, 2024Copper Contributor
Formula for entering dates with previous year
I am entering dates into a spreadsheet for 2023 rather than 2024. I would like the dates to auto-populate to the previous year rather than the current year, IE: entering 01/01 and have 01/01/23 ...
SergeiBaklan
Sep 28, 2024Diamond Contributor
1) To my knowledge current year is taken and that's not changeable.
2) Formula could be like
=DATE("20"&RIGHT(A1,2),MID(A1,3,2),LEFT(A1,2))
which returns result in other than A1 cell.