Eric58132
08-04-2010, 07:53 AM
Hi All,
Figures, I get everything all set up with my last thread and now I have a date formatting problem where it isn't actually reading the April. I enclosed an actual portion of the data that I am working with. The formula used (I went with your average one XLD) isn't finding the april. I know that this is because the date row is in text but I can't seem to format it in such a way that it CAN be read. I'm looking to somehow format the dates within an existing macro that I already have in order to maintain the same level of automation within the file. Any suggestions?
Figures, I get everything all set up with my last thread and now I have a date formatting problem where it isn't actually reading the April. I enclosed an actual portion of the data that I am working with. The formula used (I went with your average one XLD) isn't finding the april. I know that this is because the date row is in text but I can't seem to format it in such a way that it CAN be read. I'm looking to somehow format the dates within an existing macro that I already have in order to maintain the same level of automation within the file. Any suggestions?