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!