| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Finding the latest date represented in a group of cells | Excel Discussion (Misc queries) | |||
| find latest date in a row, when dates have apostrophes in it | Excel Discussion (Misc queries) | |||
| How do I find the earliest dates in a range of dates? | Excel Worksheet Functions | |||
| Find the earliest date in a range of dates? | Excel Worksheet Functions | |||
| Finding the Latest Date from Several Dates in Different Columns | Excel Discussion (Misc queries) | |||
Linear Mode
