Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old February 22nd 05, 06:09 PM
Smith295
 
Posts: n/a
Default 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   Report Post  
Old February 22nd 05, 06:20 PM
JE McGimpsey
 
Posts: n/a
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How sort dates just by day/month and NOT year if all 3 given in ce smags Excel Worksheet Functions 1 January 25th 05 03:45 AM
Need to sort dates before 1900 in proper order sandage_2000 Excel Discussion (Misc queries) 3 January 8th 05 03:31 AM
Sum between a range of dates Bruce Excel Worksheet Functions 3 January 5th 05 02:25 AM
How do I reference and sort a range of numbers in Excel 97? Old Northern Excel Worksheet Functions 3 December 14th 04 03:15 PM
I have a list of dates that I need to count based on a date range ejb030353 Excel Worksheet Functions 4 November 24th 04 02:27 PM


All times are GMT +1. The time now is 01:55 PM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright 2004-2021 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017