Count several items in multiple columns

I have this work sheet with several formulas in columns Z to AD. All of them highlighted red work fine as for as I can tell.
I am stumped with the one needed for the cell highlighted yellow AD2. It should count all the dates in AD1 that are Requested Changes Made and/or Rejected
in Column "M". AD2 is a total of today minus 8.
Equipment Change out - TEST.xlsx

Hi,

Is this what you are looking for??

I hope this helps

Hey,

Thanks so very much. That is exactly what i needed.

You're welcome.

Please don't forget to mark this thread as solved, and please click on the * next to my post to say thanks

How do I mark it Solved?

Thread Tools --> Mark As Solved