New Year Affected Formula Results

[BobBrown60]

Hello,

I have a calibration sheet to show when equipment is due and how many there are. In cells I3:J6 highlighted in yellow there should be some results. I think the new year has affected the outputs.

If someone has a chance could you please see how to correct the formulas to allow for the new year?

Thank you

[Fluff13]

Your formulae are trying to count cells in col O compared to a date in R2, but col O is just X or ""
I suspect the formulae should be looking at col M

[BobBrown60]

Thank you I didn't realize changing the formatting arrangement of columns affected the formulas.

I appreciate the help.

[Fluff13]

You're welcome & thanks for the feedback.