How can I put a range of dates in a single cell, ie: Sept 5-7 2005 , and make
it sortable?
How can I put a range of dates in a single cell, ie: Sept 5-7 2005 , and make
it sortable?
I wouldn't do this. I'd use a multiple cells (at least 2).
But if you're consistent with the format, you could just sort it based on the
text in the cell:
2005/09/05-07
yyyy/mm/dd-dd
These won't be dates, but they will be easy to sort.
vshammer wrote:
>
> How can I put a range of dates in a single cell, ie: Sept 5-7 2005 , and make
> it sortable?
--
Dave Peterson
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks