If cell value equals...

This can probably be done with a VLOOKUP formula or possibly a pivot table. How will the use "select" the server to be dealt with? Can you attach a sample workbook and mockup how you want it to perform?

Well, you were right about needing VBA. See attached. Note: I added a dropdown to keep the scheduled days consistent so the macro shouldn't generate an error. It will if you don't choose a day for each server. I also had to insert named ranges for each possible day in the calendar. See attached.

You're welcome. One of the weaknesses of this approach is that the scheduled days next to the server names is a named range, so if you add more dates beyond what's already there, you'll need to expand the name to account for all rows. If needed, I can automate that for you.

If you unhide the D column, you will find the named range MaintenanceDays. I simply selected the values, then used the name manager on the formulas ribbon to insert the name. Scheduled days refers to B2:B5 on the DataCenter sheet and was created the same way. Also, there is a named range for every cell in the body of the calendar.

Ok - I'm almost there. Not all rows will have a scheduled maintenance so there maybe blank fields in the Date column. If I removed a value from your example, it would break at

If Application.Range(strRngName).Value <> "" Then

I even tried putting in an isNull statement, but it errored out at the same spot. I also added a blank cell to the MaintenanceDays list and that still gave me the same problem. If a Null value can't be used, should I add a cell to 'ScheduledDays' and name it 'NM'. Then in the Calendar sheet, all NM values would be be written in a No Maintenance cell? I hope that makes sense.

Side question - can you remove Name cells? <--Figured it out.

You're right on the money with the NM cell concept. See attached update.