My offset formula doesn't like referencing a cell with a formula.

Issue: If you look at my calendars for Crew A and C, on certain months, values appear for non month days, like the first week of Jan for Crew A, but not on other months. The formula looks at the ops schedule. I tried copying the cells over, to hide them, and simply used =XX to copy the value and the result is the same. However, if I remove the formula from the Ops schedule and simply insert numbers, it works just fine. What can I add/change?

Personally I would change every formula so that it doesn't use OFFSET (have you noticed a bit of a delay every time you change a formula or value? OFFSET is causing that).

There is a setting in Excel options to show / hide zero values, you have it unchecked, so it hides the zeros, however they are still there for formulas to use, an empty cell, such as one of your non-month days, will match to zero, the blank cells with formulas in the Ops schedule all evaluate to zero, so the formula in the crew calendar matches to the first blank each time.

You can quick-fix it with

=IF(A5=0,"",OFFSET('Ops Schedule'!$B$3,MATCH(A5,OFFSET('Ops Schedule'!$F$4,0,MATCH(TEXT($A$3,"mmm"),'Ops Schedule'!$G$3:$R$3,0),99,1),0),0,1,1))

or change all of the formulas, so that it works more efficiently (let me know if you want to do that and I'll give you a few pointers).

Quick fix works!. Thanks. I would however accept all pointers in other options for efficiency. I will never turn down an opportunity to learn.