hi
blanks will always sort to the bottom so use a helper column.
Assuming that you termination date is in column D, in the blank column to
the right of your data put this formula.
=IF(D1="",1,0)
this will put a one by the people who have a termination date and a zero by
the people who do not have a termination date. sort by the helper column with
the termination date column as the second sort options

Regards
FSt1

"Kessa" wrote:

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