View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Kitten Kitten is offline
external usenet poster
 
Posts: 2
Default Earliest and latest dates that can be correctly represented in



"Ron Rosenfeld" wrote:

On Thu, 19 Apr 2007 20:54:01 -0700, Kitten
wrote:

What are the earliest and latest dates that can be correctly represented in
Excel?


From "Specifications" in Excel HELP:

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

--ron


Thanks heaps. Is very useful