How to sort date columns?

K

Kessa

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
 
F

FSt1

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
 
K

Kessa

Thanks a lot for your response but I'm having issues again.
I put in the formula that you requested but my question is "Am I suppose to
change the number for each different row that I want the formula to be used
on?" If so, I have been doing that and it's not working. Also "I did put in a
new column called column header and this is the column that I am placing the
formula in for each row. Is that ok?

Thanks again!
 
Top