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

FSt1
Fri Mar 14 15:23:02 CDT 2008

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

Kessa
Mon Mar 17 08:42:00 CDT 2008

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!

"FSt1" wrote:

> 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