juliegirlfriday.com
Those Pesky New Digits of the New Year | Julie: Girl Friday | Julie: Girl Friday
Much of the data I enter has a date that is from the previous month. Since Excel assumes the year is the current year, unless something else is typed, I usually just type the month and day and let the computer do the rest. In January, data entry can problematic for me because it may not be immediately noticeable if I forgot to type the correct year in a December cell. To make my life easier I use conditional formatting to highlight cells that have future dates.