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


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!