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
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…