Have searched forums and web with no luck. In the attached workbook, I import some data from web. Once imported, I have a macro that will operate depending on formulas in column G and dates in column A.

Once the data is imported the formula will not pick up the date due to the formatting that is being pulled in from the import. If I manually enter the date it will work.

I am looking for any solution (e.g. macro, formula, helper columns etc) as I just cannot figure this out.

In attached workbook, row 5 has the date manually entered so you can see what I am talking about.

Any help is appreciated. I have tried a couple trim and len formulas in extra columns with no luck but that may be due to my limited knowledge.

Thanks in advance,

BigDawg15

VBMAX BigDawg15.xlsm