how do I use different year for date auto complete

  • Thread starter Thread starter Vance
  • Start date Start date
V

Vance

In a date formatted field, when I type in the month and day and tab, the
current year (2010) is entered. Is there a way to cause a different year
(2009) to be entered instead?
 
Excel will use the year of the system date.

So you could cheat and change the computer's date to the year you want.

Remember to change it back when you're done.
 
You could use a formula in a helper row/column:
=DATE(2009,MONTH(A2),DAY(A2))

or (use w/ caution) temporarily change your system date to a 2009 date.
 
Back
Top