Forum Discussion

CrabCrust's avatar
CrabCrust
Copper Contributor
Sep 20, 2022

Countif Query

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 🙂

excel
  • OliverScheurich's avatar
    OliverScheurich
    Gold Contributor
    Sep 20, 2022

    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.

     

Resources