Default year in date entry

  • Thread starter Thread starter Stan Brown
  • Start date Start date
S

Stan Brown

(Excel 2003)

When I enter e.g. 12/30 in a cell, Excel interprets that as the date
2007-12-30, as expected. But when I enter 1/6, Excel interprets that
as last January, not next week.

Is there any way to tell Excel that dates before a certain date in
the year should be interpreted as next year, not this year?
 
Stan,
Entering 1/6 can also result in 0.1666
Including the four digit year when entering dates is good practice.
The cell can be formatted to display what you want.
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)



"Stan Brown"
wrote in message
(Excel 2003)
When I enter e.g. 12/30 in a cell, Excel interprets that as the date
2007-12-30, as expected. But when I enter 1/6, Excel interprets that
as last January, not next week.

Is there any way to tell Excel that dates before a certain date in
the year should be interpreted as next year, not this year?
 
If you enter something that looks like a date to excel, excel will see it as a
date.

If it needs to add the year to make it a real date, it'll use the current year.

So you can either enter the year, change the pc's system date to the year you
want (and change it back when you're done) or wait until next week to enter
those dates <bg>.
 
Sat, 29 Dec 2007 08:51:09 -0600 from Dave Peterson
If it needs to add the year to make it a real date, it'll use the
current year.

So you can either enter the year, change the pc's system date to
the year you want (and change it back when you're done) or wait
until next week to enter those dates <bg>.
Click to expand...

Thanks, Dave. That's what I was afraid of.

It's not a huge deal, but I was hoping here might be some sort of
threshold, as I believe there is for deciding which century to use
when a two-digit year is entered.
 
Back
Top