I have a large excel database of over 7000 events. Around half of them have schedule information in their row - that is to say in the column that shows when it is happening they have something in there.
The problem is that this data has been input in a variety of ways - some of them have 05/05/2012 others have "June - October", others have Saturday, 6th march 2012 - Sunday the 7th of March 2012.
I am looking eventually for a way to be able to query this data in a useful way - i.e. say "what events are ongoing on date X", and the first step to that I think must be to get all the dates in the same form.... this seems like it is impossible to do automatically or with any function excel knows... but I thought it might be worth asking the experts in case they had any wizardry to achieve this seemingly impossible task?!! Thanks!