Sorting by date when the date isn't exact

K

Kim

I have a "timeline" spreadsheet that has a column for the date on which the
event occurred. Some of the entries do not have an exact date. For example,
we might know that it happened sometime prior to 3/18/05 and after 03/01/05
(<=3/18/05)but not sure of the exact date. Is there a way to represent a
date frame so that it can be included in a sort?

Thanks, Kim
 
D

Dave Peterson

Maybe you could give it just one date, but then give that cell a custom format:

"Around " mm/dd/yyyy

(The "Around" will show up in the cell--but it won't change the value of the
cell.)
 
Top