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: