I have some workers such as:
For example three of my workers' Id is expired, how do I get it using formula like countif or any similar formula please help me. Thanks
@Mobarak039 If you want to check "expired" as compared to Today's date, use Today() in the criterion. If you want to compare against a specific date in cell M1, use cell M1 as reference in the criterion.