Countif not returning the value I need.

[JJenkx]

Please forgive the noobness here. I didnt know how to sum 2 cells together at the start and managed this monstrosity after one month of free time. Cell n408 is returning the date I want and cell p408 is not. Once I understand why I can fix the rest. Thanks for any insight.


https://1drv.ms/u/s!AnGyPf0O5lMAgQHrvAYZef2NTre6?e=HjBzWS

 

[Special-K99]

Me thinks that Special-K99 & I are looking at different sheets.
Not sure which sheet you were referring to, but I was talking about "MN SN 2" and I think Special-K99 is referring to "MN SN 1"

I wondered why we were talking about different things!