The following feature seems to have been requested in forums often in recent years. As it has not been implemented yet, I'd like to bring this to your attention:
When doing my accounting in January, I need to enter numerous dates from the previous year.
It's very tedious to always enter the same (previous) year for each of the dates. If I don't, Excel uses the current year, which is not what I want.
There are many workarounds available: (a) Write a script, (b) use a formula (e.g. "xx - 365", or even more complex, given leap years) etc. … But these don't work with pre-built Excel worksheets.
Hence, I'd like to propose the following:
-
Excel should provide a "Default Year" text input field in Excel's Formulas or Data ribbon tab, pre-set with the current year. (E.g.: "Default Year: [2022]")
-
The user then should be able to edit the text field and change the year value therein.
-
Excel is supposed to use that year value from this input field whenever the user manually types a date, comprising only day and month, into a cell.
-
The year value should not be an application property but instead be unique to each active Workbook. So, each Workbook may use its own default year value. When, for instance, three Workbooks are open at the same time, each of them may use another default year for the above mentioned purpose.
-
The default year value should not be persisted along with the Workbook. Instead, the value should be initialized to the current year whenever a Workbook is being opened.