Try perhaps:
=IF(OR(I2>=TODAY(),L2="Refresher"),"Valid",IF(AND(I2<TODAY(),COUNTIFS(A:A,A2,E:E,E2,L:L,"Refresher")),"","Expired"))
copied down
Try perhaps:
=IF(OR(I2>=TODAY(),L2="Refresher"),"Valid",IF(AND(I2<TODAY(),COUNTIFS(A:A,A2,E:E,E2,L:L,"Refresher")),"","Expired"))
copied down
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks