Cells w/Date Formats should know when to use current/prior year

[Guest]

With the calendar capability, it seems as though one would be able to enter
only the month and day for planning upcoming events a year out. Example: On
12/1/2005, I should be able to key in "11/30" and get a return of
"11/30/2006" instead of "11/30/2005."

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/com...dg=microsoft.public.excel.worksheet.functions

 

[Biff]

Hi!

12/15

What year do I want to place that date in?

Biff

 

[Peo Sjoblom]

Why do you assume that if somebody types part of a date that has a day that
is later than today that they would want to change year?
What if someone types 05/05 on May the 10th 2005 does that mean
May 2005 or does that mean May 5th 2005 or May 5th 2006? I have many qualms
with excel but using current year is not one of them. IMHO it would be
better it wouldn't recognize 11/30 as a date at all, that would save a lot
of headaches for people importing text files or copy and paste where Excel
converts non dates to dates


--

Regards,

Peo Sjoblom

With the calendar capability, it seems as though one would be able to enter
only the month and day for planning upcoming events a year out. Example: On
12/1/2005, I should be able to key in "11/30" and get a return of
"11/30/2006" instead of "11/30/2005."

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/com...dg=microsoft.public.excel.worksheet.functions