Set an Excel Spreadsheet to return a Default Year

Copper Contributor

Is it possible to make a spreadsheet default to the following year?

For example, I type 12 Jul and, subject to my date format, the cell displays 12/07/22. I need it to automatically display 12/07/23 as the spreadsheet is for calendar dates in 2023.

Thanks so much 

1 Reply

Hello @SueB33 !

You can change the date format to a default value.

Example : "2023"-mm-dd


For more information on How to change the date format