Excel dates prior to 01/01/1900

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Excel does not assign a serial number to dates prior to 1/1/1900. Dates
prior to this cannont be sorted or used in sum conditional statements. It
seem like a simple fix and is and annoyance when needed.

----------------
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...6-40c616ce2719&dg=microsoft.public.excel.misc
 
The VBA date variable goes back to the year 100. John Walkenbach has an
excellent free utility for working with extended dates.

http://j-walk.com/ss/excel/files/xdate.htm


Troy said:
Excel does not assign a serial number to dates prior to 1/1/1900. Dates
prior to this cannont be sorted or used in sum conditional statements. It
seem like a simple fix and is and annoyance when needed.

----------------
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.
Click to expand...
http://www.microsoft.com/office/community/en-us/default.mspx?mid=4a6da6ed-be
8e-4918-8366-40c616ce2719&dg=microsoft.public.excel.misc
 
I agree with Troy. This suggestion has been out here for YEARS - FIX IT NOW
for ALL VERSIONS. We pay enough money for this software. Birth dates and
Historical dates go back before 01/01/1900 and should stored and used the
SAME way. Don't even bother suggesting the ADDIN again NO addin should be
NEEDED for dates. IT is totally ridiculous that all dates back in HISTORY
can't be used correctly and the same. OTHER software handles dates with no
problem - so should microsoft office excel in ANY version.
 
Back
Top