Forum Discussion
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 auto-populate instead of 01/01/24.
Also, is it possible to create a formula where I can just enter the numbers and no slash, and have the date fill in, IE: enter 010123 and have it fill-in as 01/01/23. Thank you!
1 Reply
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.
