To count the expired ID

Copper Contributor

 I have some workers such as:

 expird id.jpg

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

1 Reply

@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.Countif.png