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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Vba to change displayed year automatically. 14
Autocomplete -Date 3
Date Difference 4
accepting most recent date across columns 10
How to enter excel dates for last year? 10
Convert Text to Date Month and Year 1
Sumproduct question and why cant I find my previous questions? 3
Datedif gives wrong result 1

Back
Top