Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old January 9th 05, 06:27 AM
DickG
 
Posts: n/a
Default Entering dates in Excel 2002

Is it possible to enter and use dates prior to January 1,1900, in
calucaltaions in Excel 2002. Specifically trying to calculate the number of
days between two dates where one or both of the dates are prior to January 1,
1900. If so how?

  #2   Report Post  
Old January 9th 05, 01:06 PM
Ron Rosenfeld
 
Posts: n/a
Default

On Sat, 8 Jan 2005 21:27:01 -0800, "DickG"
wrote:

Is it possible to enter and use dates prior to January 1,1900, in
calucaltaions in Excel 2002. Specifically trying to calculate the number of
days between two dates where one or both of the dates are prior to January 1,
1900. If so how?


You would need to use a VBA routine for this (or write some complex
string-parsing formulas).

Excel by itself does not recognize dates prior to 1900.

What is your potential date range?
--ron
  #3   Report Post  
Old January 9th 05, 01:10 PM
Nick Hodge
 
Posts: n/a
Default

Dick

From Help in XL2003

Earliest date allowed for calculation
January 1, 1900 (January 1, 1904, if 1904 date system is used)

Latest date allowed for calculation
December 31, 9999

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
HIS


"DickG" wrote in message
...
Is it possible to enter and use dates prior to January 1,1900, in
calucaltaions in Excel 2002. Specifically trying to calculate the number
of
days between two dates where one or both of the dates are prior to January
1,
1900. If so how?



  #4   Report Post  
Old January 9th 05, 03:56 PM
Dave Peterson
 
Posts: n/a
Default

John Walkenbach created an addin that allows you to work with dates before 1900.

You can find it he
http://j-walk.com/ss/excel/files/xdate.htm


DickG wrote:

Is it possible to enter and use dates prior to January 1,1900, in
calucaltaions in Excel 2002. Specifically trying to calculate the number of
days between two dates where one or both of the dates are prior to January 1,
1900. If so how?


--

Dave Peterson


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? Richard Excel Discussion (Misc queries) 1 January 5th 05 09:36 AM
How do I update Excel 2000 macros to work in Excel 2002? BobPetrich Excel Discussion (Misc queries) 3 January 4th 05 05:06 PM
Excel 2003 back to Excel 2002 Pete Carr Excel Discussion (Misc queries) 3 December 27th 04 09:11 AM
Macro in Excel 2002 to save a workbook to a FTP location Lloyd Excel Discussion (Misc queries) 0 December 21st 04 03:49 PM
Can you print labels using Excel 2002 in a Word 2002 mail merge? Individual_ Excel Discussion (Misc queries) 3 December 17th 04 09:39 PM


All times are GMT +1. The time now is 08:55 PM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright 2004-2021 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017