Hi,
I have a RAID log and need a formula to check if the risks were updated on a specific date. Please see image attached.
Logic: Formula to check date in A2 and see if all OPEN items have the same date if criteria met YES if not NO (All Open items must have the date in cell A2 for a YES)
I need the formula to disregard CLOSED items as well please. Two criteria searches one for date in A2 in column F and only look for that date for OPEN items and ignore CLOSED.
I have a RAID log and need a formula to check if the risks were updated on a specific date. Please see image attached.
Logic: Formula to check date in A2 and see if all OPEN items have the same date if criteria met YES if not NO (All Open items must have the date in cell A2 for a YES)
I need the formula to disregard CLOSED items as well please. Two criteria searches one for date in A2 in column F and only look for that date for OPEN items and ignore CLOSED.