I have a list of dates, and I need to count how many of those dates are strictly greater than 7 and 14days from today’s date, also which is = 7 days. I tried to use the formula =COUNTIF(J5:J22, “>”&TODAY()+7) but it counts all numbers as the same date. The list has dates from 05/01 till 05/26 and obviously has dates over 14 and 7 days…
I tried this formula =COUNTIF(J5:J22, “>”&TODAY()+7)… I expect to bring me the total of >=14days, >7 days and <=7 days.
New contributor
David Knight is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.