vba not identifying date that is generated by a formula question

Good Evening! I was hoping someone could help me possibly edit this code so it would recognize dates which are generated via a formula. The code works great if the date is in a format like 01/17/15, but if the date 01/17/15 as an example is generated by a formula it isn't recognized. I'll try and set up and attach a sample workbook but currently the original is fairly complex and it may take a little bit of time. So in the mere chance someone can recognize the issue here is the code that I'm currently using:

Please Login or Register  to view this content.

Essentially this code takes certain Holiday dates from the "Holiday" worksheet from cells A2 thru A12 and then puts an "H" on any monthly titled worksheet directly underneath the same date. The "H" would go in Row 2 directly underneath the same date which is now formula based but in Row 1. Hope this makes sense. The formula that generates the date looks like this:

Please Login or Register  to view this content.

Thanks for your time and advice!

Give this a try. It should be date format independent.

Please Login or Register  to view this content.

It's not tested. I cannot load an .xlsb file with My Excel 2003.

Please Login or Register  to view this content.

Try this modification

Please Login or Register  to view this content.

Missing a space for what it's worth.

Dim destSh As Worksheet
.....^

Here's AlphaFrog's Code after little fix

Please Login or Register  to view this content.