I am using the CountIfs formula, =COUNTIFS(A1:A100, "John", B1:B200,"<="&TODAY()+30).
In column A I have Names (John, Bill, etc...), In column B I have Project Deadlines as Dates. I have three cells that will contain the results of the formula (one cell for 30 days, another for 60 days and another for 90 + days). I need the formula to provide me how many deadlines John has within 30 days, 60 days, and 90 + days.
Your help is very appreciated!!
Bookmarks