| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
How do I get Excell to sort dates that range from 1800 to 1900's
I have posted a cemetery survey on Excell spreadsheet. When I try to sort
the birth dates or death dates in ascending or descending order the range of 1900 dates will sort but the 1800 dates fall after the 1900 and will not sort. Why? Is this inherit with this program? |
|
#2
|
|||
|
|||
|
The WinXL default dates start with 31 December 1899, so earlier "dates"
are interpreted as Text. You can use helper columns and text functions (LEFT(),RIGHT(),MID()) to put the Year, Month and Day in separate columns, then sort. Take a look here for additional workarounds: http://j-walk.com/ss/excel/files/xdate.htm In article , "Smith295" wrote: I have posted a cemetery survey on Excell spreadsheet. When I try to sort the birth dates or death dates in ascending or descending order the range of 1900 dates will sort but the 1800 dates fall after the 1900 and will not sort. Why? Is this inherit with this program? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How sort dates just by day/month and NOT year if all 3 given in ce | Excel Worksheet Functions | |||
| Need to sort dates before 1900 in proper order | Excel Discussion (Misc queries) | |||
| Sum between a range of dates | Excel Worksheet Functions | |||
| How do I reference and sort a range of numbers in Excel 97? | Excel Worksheet Functions | |||
| I have a list of dates that I need to count based on a date range | Excel Worksheet Functions | |||
Hybrid Mode
