Sorting by date when the date isn't exact

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sorting Dates 1
Problem formatting dates from CSV file 2
UNABLE TO SORT DATE 1
Access Running Balance in Access 1
Dates Milestones 6
sorting dates in a worksheet 3
Pivot Table? ID, Date, Value sorting 4
Formatting Date Field 5

Back
Top