Date range to calendar

this is possible if you upload excel file with designed result.
Thanks,

Yes that is right, with the layout and designed result.

You can try this:

The cells in Blue in column A are the list data for the 2 DV dropdows in C2 and C3 (Green) (you can hide Column A if you wish)
the cells in yellow are the days that match the holiday range in column D

Hope this helps

Edit-
NOTE- the dates in holiday list must stay in the same format, I did not build in any checking for this, so if the format or spacing changes, errors will pop up..

Where abouts ? is working fine here

I can't do much with a screenshot...I tackled this on the first one because it looked pretty simple, you have a string range of dates, break the string and make them values... without seeing your formatting, how the date ranges are figured, what kind of formatting (AND I MEAN see it in an actual workbook where we can manipulate it) there isn't much more I can do, which is what bebo was getting at from the start...give us something to work with...read my signature for further clarification

Edit-
After breaking out my reading Mag (that pic is SMALL), what it looks like is you have forgotten a $ or 2 on the references...some references are locked to specific cells, some to rows, some to columns...if the dollar sign is left out, they are no longer referencing the proper data, thus the errors...just a guess tho, without the sheet, it's pretty much impossible to tell

Heres the best I got without seeing what you are ACTUALLY working with...any range problems are yours(all 4 of these work quite well with the SCREENSHOTs provided), first sheet is what I already uploaded, second is same, but allows some flexibility in the way the dates are are dealt with,3rd sheet and fourth both require some work on your part to get the "dates off" range to an acceptable format...BUT, they all do work, I have spent the time to create the WB, I'd appreciate it if YOU took the time to explore the options offered, Because if you come back with a "It does not work for me" post, with no example WORKBOOK of what doesn't work, I will just say goodbye and farewell
HolidayCalendarSol4.xlsx

See if this works for you
Had to add helper columns in '2012'and 'Season 1' tabs to get the dates into a usable form,you can hide these if needed

Hope this helps