Prior year assumption in December dates entered in January
Many people enter recent dates into excel to balance bank accounts etc and Excel always assumes the year in dates entered as the current year. This makes everyone not need to type out the year except for about half a month every year.
Ir Regardless commented
I like Mike Lyons suggestion except that I would include an option of either:
-Use the prior year
-Use the prior year when entering December dates
I cannotg enter the dates and get numbers instead. How do I correct this?
Mike Lyons commented
I understand the desire to keep the default behavior as-is so as to not break existing users. However, what if there were a setting in the advanced options that allowed users to choose how Excel picks the year for dates entered with just month & date?
The options could be:
1. Use the current year (the default, and what Excel does today)
2. Use the year that makes the date closest to today (up to a half year off in either direction)
3. Use the year that makes the date the most recent one in the past (up to a whole year off, only in the past)
What do you think?