how do I use different year for date auto complete

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?
 
D

Dave Peterson

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.
 
L

Luke M

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.
 
Top