cant get dates that are in text for to change to date form

Hi superchew,

One way you can do it is with a formula, maybe like this:

Formula:

Please Login or Register  to view this content.

You can also do it with a macro like this:

Please Login or Register  to view this content.

Whoops, my bad...

Please Login or Register  to view this content.

For future reference, please do not upload your entire file is it that big that it needs to be zipped. Most of those sheets have no bearing on your question, and many members will not even consider (or may not be allowed to) opening large files

All we need is a SMALL representative sample of what you have - and what you want...if necessary, explain what ranges you need to work with

You can probably speed that file up by changing from full-column references to ranges...
=COUNTIFS('Safety Contacts'!F:F, $A2, 'Safety Contacts'!$E:$E,">=" & 'Score Card'!$T$2,'Safety Contacts'!$E:$E,"<=" & 'Score Card'!$V$2)
to
=COUNTIFS('Safety Contacts'!$F$2:$F$10000, $A2, 'Safety Contacts'!$E$2:$E$10000,">=" & 'Score Card'!$T$2,'Safety Contacts'!$E$2:$E$10000,"<=" & 'Score Card'!$V$2)
etc

To pull the date from Incident Sheet, try this in a helper column...
=DATEVALUE(LEFT(E2,FIND(" ",E2)-1))
copied down and formatted as date