ExcelBanter - Earliest and latest dates that can be correctly represented in Exc

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Earliest and latest dates that can be correctly represented in Exc (https://www.excelbanter.com/excel-discussion-misc-queries/139699-earliest-latest-dates-can-correctly-represented-exc.html)

Kitten

Earliest and latest dates that can be correctly represented in Exc

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

Ron Rosenfeld

Earliest and latest dates that can be correctly represented in Exc

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

Kitten

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

All times are GMT +1. The time now is 03:31 AM.