Count if Expiration Date is in the next 3, 14, 30 Days without counting Past Expiration Dates


My Formula is "=COUNTIF({Expiration Date}, <TODAY(3))" switching out the number for the appropriate timeframe.

When I do a filter on the sheet it is referencing to there is only 1 expiring in the next 3 days however the formula keeps giving me an answer of 2.

I am unsure if it is counting the 2 that are past the expiration date or what.


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!