How do I sort nulls within date field in Excel

[Guest]

When I attept to sort a date column, either ascending or descending, the
dates always sort at the top. Is there code or a way to sort to produce a
result that the nulls (blank dates) within the column will appear at the top
of the column and the dates will folow in ascending order below the nulls?

Any help is greatly appreciated.
thank you.

 

[Dave Peterson]

Maybe you could just sort, then move them where you want.

Or fill the empty cells with 0's.
sort your dates/0's
replace all the 0's with nothing (Match entire cell contents, though)

 

[Guest]

Hi,
I do not have a complete answer, but I belive it can be done with "lists",
where a list is created and used as the sort order. Maybe one of the MVPs can
help further, but that was as close as I could get. You might try help and
"lists" to see if you can define the sort in a better way.
Thanks,