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