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!

​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!  Read More

​