How to sort date columns?
I have a spreadsheet with the following column headings:
Name
Occupation
Start Date
Termination Date
The issue that I'm having is that I'm trying to sort by the termination
date. Not all employees have a termination date so therefore their row is
blank. I need excel to be able to sort by termination date but I also need
it to place all people that have a termination date at the bottom of the
spreadsheet. I tried to sort by the termination date but it's doing the
opposite of what I would like. It places all that have a date at the top
followed by the blanks. Is there something that I can do to solve this issue?
Thanks for your help
|