Forum Discussion
CrabCrust
Sep 20, 2022Copper Contributor
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 a...
OliverScheurich
Sep 20, 2022Gold Contributor
=SUMPRODUCT((Table134>=TODAY())*(Table134<=TODAY()+365))You can try this formula in order to count the dates from today until today plus 365 days.