sorting date of birth list

  • Thread starter Thread starter Guest
  • Start date Start date
How about selecting that column and doing
Data|Filter|Autofilter.

You can filter to show the dates greater than December 31, 1945.

=====
Or you can sort by those dates and then delete the ones you don't want. There's
nothing special about sorting by dates--excel treats them as numbers. And the
format is just that--a format. It doesn't change the underlying value (or
date).
 
Dave said:
How about selecting that column and doing
Data|Filter|Autofilter.

You can filter to show the dates greater than December 31, 1945.

=====
Or you can sort by those dates and then delete the ones you don't want. There's
nothing special about sorting by dates--excel treats them as numbers. And the
format is just that--a format. It doesn't change the underlying value (or
date).
Click to expand...
If you want to see the dates before 1946 the filter should show the
dates earlier (or less than) 1/1/1946.

Bill
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

how to sort a column containing date of birth? 1
How to enter a date in DD-MM-YYYY format 2
printing report with date 3
date sorting 3
sorting base on date 6
Getting MM-DD HH:MM out of Julian date 4
date format convert 2
Excluding Friday & Saturday from the calculation 1

Back
Top