Hey everyone,
I have a question. I just started a new job, and for the past 10+ years they have manually been inputting post logs of when commercials ran, because nobody can figure out the bulk upload feature. Well... I'm lazy and don't want to manually input these logs... so I'm figuring it out.

Here is the only problem I am experiencing at the moment. I get the logs in 3 different formats. The date has to be formatted as YYYYMMDD (i.e. 20110101 for Jan 1st 2011) I currently get it stored as text as 01/01, stored as text as Jan 01, and stored as text as 01/01/2011 8:35 pm (date and time in one cell).

How can I write a macro to transform date as a text value into a date format? Thank you so much!