Earliest and latest dates that can be correctly represented in Exc

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

Guest

What are the earliest and latest dates that can be correctly represented in
Excel?
 
What are the earliest and latest dates that can be correctly represented in
Excel?
Click to expand...

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
 
Ron Rosenfeld said:
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
Click to expand...

Thanks heaps. Is very useful
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to invert column entries in Excel 1
Chinese tombs yield earliest evidence of cannabis use 0
Wishing there was a 'maxif/minif' - your help appreciated! 4
HELP! Need to have earliest test record data 2
How do I find the earliest date? 1
Return earliest date 3
Can Excel return the earliest date from a list? 2
lookup max min 3

Back
Top