Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Date sorting problem
Using Excel 2002 - we have huge list of dates that often have no DAY, or
that only have a year. We have to sort them and don't know how. Such as: 12/31/02 12/00/02 2002 Thank you, Ardell |
#2
|
|||
|
|||
Date sorting problem
You need to make some simple assumptions. For example, if there is no day,
then assume the day=1. If there is no month and no day, then assume 1 jan. Then re-format the data. Then sort in the usual fashion -- Gary's Student "Ardell" wrote: Using Excel 2002 - we have huge list of dates that often have no DAY, or that only have a year. We have to sort them and don't know how. Such as: 12/31/02 12/00/02 2002 Thank you, Ardell |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I calculate if a date is in a certain time frame? | Excel Worksheet Functions | |||
Date & Time problem | Excel Worksheet Functions | |||
Date problem using VBA | New Users to Excel | |||
Date formatting problem | Excel Discussion (Misc queries) | |||
problem with formatting cell to date format | Excel Worksheet Functions |