Sorting by date (ignoring blanks)
Sorry for the easy question. I've looked around and can't find the answer.
I have a report full of dates, some of the dates are also blank. When I sort the column by ascending date, it starts with all the blanks, then the earliest date to the latest.
when i sort descending, it gives me the latest date first to the earliest, the the blanks.
i'm looking for, earliest date to latest date THEN blanks.
this is in a report, so i can't use a formula.