Greetings All,
I have a list of dates in column A and a list of names in column B. I'm trying to find the first Monday in column A if the name in column B equals "John". Next, I'd want to list the second Monday in A if the name in column B equals "John". What would be the formulas for this?
Thanks in advance!!
I have a list of dates in column A and a list of names in column B. I'm trying to find the first Monday in column A if the name in column B equals "John". Next, I'd want to list the second Monday in A if the name in column B equals "John". What would be the formulas for this?
Thanks in advance!!