CountIF Function for Licensures Expiring w/in 90 Days
Hi! I would like to get help on writing a coutif function that will count all licensures expiring within 90 days. My current formula is below. It is not giving me the right number on my dashboard when I double check it against my report (which shows me all licensures expiring in the next 90 days).
=COUNTIFS({BLS Expiration 2}, <=TODAY(90), {BLS Expiration 2}, >TODAY())
Thank you in advance!!
😊
Best Answer
-
=COUNTIF({BLS Expiration 2}, AND(@cell <=TODAY(90), @cell>today())
Mark
I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.
Answers
-
=COUNTIF({BLS Expiration 2}, AND(@cell <=TODAY(90), @cell>today())
Mark
I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.
-
That works! Thank you so much!
-
Glad you found a solution. Please accept an answer to close the discussion. Thank you for using the Community.
Mark
I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.
Help Article Resources
Categories
Check out the Formula Handbook template!
