how do I use different year for date auto complete

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

 

[Fred Smith]

Not with autocomplete.

Regards,
Fred

 

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

 

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