What are the earliest and latest dates that can be correctly represented in Excel?
K Kitten Apr 20, 2007 #1 What are the earliest and latest dates that can be correctly represented in Excel?
R Ron Rosenfeld Apr 20, 2007 #2 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
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
K Kitten Apr 20, 2007 #3 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
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
