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



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