how do I use different year for date auto complete
 

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?

how do I use different year for date auto complete
 

Not with autocomplete.

Regards,
Fred

"Vance" wrote in message
...
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?

how do I use different year for date auto complete
 

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.

Vance wrote:

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?

--

Dave Peterson

how do I use different year for date auto complete
 

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.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Vance" wrote:

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?