How do I use CountIF to count items 30 days or less from Today without counting items in the past?
I have a CountIF formula set to count the number of cells that have dates 30 days or less from Today's date using the Today function, however it is also counting dates that are in the past. I only want to count the number of dates that are 30 days or less in the future.
Any way I can exclude past dates?
Here is what I am using for a formula:
=COUNTIF([Date Needed By]:[Date Needed By], <TODAY(+30))
Help Article Resources
Check out the Formula Handbook template!