Default year in date entry

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Stan Brown - 29 Dec 2007 12:38 GMT

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

Signature

Stan Brown, Oak Road Systems, Tompkins County, New York, USA
http://OakRoadSystems.com/
"If there's one thing I know, it's men. I ought to: it's
been my life work." -- Marie Dressler, in /Dinner at Eight/

Reply to this Message

Jim Cone - 29 Dec 2007 14:46 GMT

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.

Signature

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?

--
Stan Brown, Oak Road Systems, Tompkins County, New York, USA
http://OakRoadSystems.com/
"If there's one thing I know, it's men. I ought to: it's
been my life work." -- Marie Dressler, in /Dinner at Eight/

Reply to this Message

Dave Peterson - 29 Dec 2007 14:51 GMT

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

> (Excel 2003)
>
[quoted text clipped - 10 lines]
> "If there's one thing I know, it's men. I ought to: it's
> been my life work." -- Marie Dressler, in /Dinner at Eight/

Signature

Dave Peterson

Reply to this Message

Stan Brown - 29 Dec 2007 15:09 GMT

Sat, 29 Dec 2007 08:51:09 -0600 from Dave Peterson
<petersod@verizonXSPAM.net>:

> > 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
[quoted text clipped - 9 lines]
> the year you want (and change it back when you're done) or wait
> until next week to enter those dates <bg>.

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.

Signature

Reply to this Message