Jan 16 2022 01:42 PM
I am looking for a formula to count items in column G with a date (some are blank/open) and have days open >30 in column H.
Please Help!
Jan 16 2022 02:14 PM
Solution=COUNTIFS(G2:G100,"<>",H2:H100,">30")
Jan 16 2022 02:14 PM
Solution