Column A contains dates. Column B also contains dates but each corresponding cell is a later date than Column A. Column C contains team identification codes e.g. AT521.
I am having difficulty producing an array formula that will count if Column C equals team code AT521 AND Column B subtracted from Column A is greater than or equal to 91 days.
I would appreciate any help.
I am having difficulty producing an array formula that will count if Column C equals team code AT521 AND Column B subtracted from Column A is greater than or equal to 91 days.
I would appreciate any help.