Count between two dates with two conditions

[rhett7660]

Hello,

R10C1 = 01/01/2016
R11C1 = 01/01/2018
R12C1 = 01/01/2017


I want to do the following:

Count Column 1 if it falls between today and 2 years from today and 1 year from today. But I do not want it to be counted if the date is less than today. I don't want to count ones that are past due. The below formula is also counting the ones that are past due. So my totals look skewed since I have a total showing "due in two years or less" and a total for "over due".

I have tried the following: =COUNTIFS(CFMB!P$12:P14,"<="&TODAY()+730,CFMB!P$12:P14,"<="&TODAY()+365)

I have a separate column for the over due items based on the date.

[rhett7660]

I think I just figured it out, I needed to add another condition for the equal or less than today not to show. Still testing.

[rhett7660]

I used the following:

=COUNTIFS(CFMB!P$12:P14,"<="&TODAY()+730,CFMB!P$12:P14,"<="&TODAY()+365,CFMB!P$12:P14,">"&TODAY())

Nope this didn't work either.

[rhett7660]

Nope not solved.... Ugh.

[rhett7660]

Ok, I was able to get what I wanted it to do by using the following formula:

=COUNTIFS(CFMB!P$12:P14,"<="&TODAY()+728,CFMB!P$12:P14,"<>"&TODAY()+364,CFMB!P$12:P14,">"&TODAY())