Countif Query

New Contributor

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

1 Reply

@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.

sumproduct.JPG