Holiday / Vacation calendar #value errors

Hello,

I had some help on here before, but for some reason every time I open up this file, I am getting #VALUE! errors on some cells and not others, and the Calendar tab is not pulling over the data for me.

The #VALUE! errors are happening on the 1st tab labeled "Season 1" and also on the "2012" tab on certain cells only, not sure why it works on some and not others.

My main area that I would like to work and be fixed would be for the "Calendar" tab to work properly. I am using Excel 2010 if that makes a difference. I have labeled on the "Calendar" tab on what I would like to happen. If anyone can help out, I much appreciate it!

Thank you so much!

Just to add to this, I have opened the file and it appeared to work, but the minute I selected "Enable Editing" it all disappeared. So the code appears to be working, but when I select Enable Editing everything vanishes.

Jonmo1, the 07/05/2012 - 07/05/2012 are copied over from a scheduling software. That would represent July 5th, 2012.

Well your formula was trying to convert
07/05/2012 to May 7th, not July 5th.

Therein was the problem when it got to say 05/21/2012.. There is no 21st month.


Also, it looks like you're making your task WAY more difficult than it needs to be.
Unless your sample is not consistent with your actual data..

Your strings in column C appear to be VERY consistent in lenth..
ALWAYS in the format of
mm/dd/yyyy - mm/dd/yyyy

If this is true, it is far simpler...
Try
G4: =DATE(MID(C4,7,4),LEFT(C4,2),MID(C4,4,2))
H4: =DATE(RIGHT(C4,4),MID(C4,14,2),MID(C4,17,2))