Countif Query

[CrabCrust]

Good Afternoon,

I have a table which contains 5 columns titled 'Date1, Date2, Date3, Date4 and Date5'

We enter dates in this boxes and I want a Countif Column that will count the dates that are within 1 year of todays date. I am currently using this -

=COUNTIF(Table134[@[Date 1]:[Date 5]],">1/9/2021") which will correctly tell me the number of dates that happen dafter 1/9/21 but I want it to happen automatically if it is within a year. 

Thank you :)

[#2]

@CrabCrust 

=SUMPRODUCT((Table134>=TODAY())*(Table134<=TODAY()+365))

You can try this formula in order to count the dates from today until today plus 365 days.