Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date Range Question
Hello.
We have a spreadsheet where the data in column A are dates. Some of the entries, however, have been put in as date ranges in one cell (i.e., 01/01/06 - 01/11/06). We need to be able to still sort the list by date. Can cells that have a date range entered still be formatted to read as a date so the sorting includes them? This is an example of what we have: 12/04/05 12/06/05 01/01/06 - 01/11/06 12/12/05 01/12/06 01/01/05 This is what we need to sort to without splitting the column: 01/01/05 12/04/05 12/06/05 12/12/05 01/01/06 - 01/11/06 01/12/06 Thank you in advance for any suggestions. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need help with date range | Excel Discussion (Misc queries) | |||
HELP - Date Range In 1 Cell Calculation | Excel Worksheet Functions | |||
adding occurrences for date range | Excel Discussion (Misc queries) | |||
adding occurrences for date range | Excel Discussion (Misc queries) | |||
Date Format Question | Excel Discussion (Misc queries) |