Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sorting by Date when some dates span over several days
Hello! I am creating a spreadsheet that is a list of events for various
organizations. one of the columns is the date of the event, and many events span over several days, so the date is written as Januray 1-3, 2008. I have this column automatically formatted to read the data as a date, so if I type 1-2-08 it automatically changes it to read January 2, 2008. The chart is sorted first by organization, then by date. If I type 1-2-4-08, it can't make sense of that, so I have to manually retype it to read January 2-4, 2008. Is there any sort of programming I can do to make excel understand what Januray 2-4, 2008 means and have it sort accordingly? Thank you! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sorting by Date when some dates span over several days
I forgot to say that I'm using Excel 2003. Thanks!
"Sarah C" wrote: Hello! I am creating a spreadsheet that is a list of events for various organizations. one of the columns is the date of the event, and many events span over several days, so the date is written as Januray 1-3, 2008. I have this column automatically formatted to read the data as a date, so if I type 1-2-08 it automatically changes it to read January 2, 2008. The chart is sorted first by organization, then by date. If I type 1-2-4-08, it can't make sense of that, so I have to manually retype it to read January 2-4, 2008. Is there any sort of programming I can do to make excel understand what Januray 2-4, 2008 means and have it sort accordingly? Thank you! |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sorting by Date when some dates span over several days
Hello Sarah,
I suggest to use Excel standard data types: Take two cells for a date range and put in start date and end date, for example. You avoid major hickups with data input, processing and output. Even if you are forced to finally show the data as you described it then you only need to deal with the output side... Regards, Bernd |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Formatting Dates calculating 10 days and 30 days from a certain date | Excel Worksheet Functions | |||
TWO DATES,150 DAYS APART,NEED ONE DATE TO TURN RED AFTER 150 DAYS | Excel Programming | |||
Inconsistent excel 2007b2 time calculations that span whole days | Excel Discussion (Misc queries) | |||
Dividing a time span into shifts - overlapping days | Excel Worksheet Functions | |||
Sorting Dates in Days of the Week | Excel Discussion (Misc queries) |