Forum Discussion
Solved
Calculating date over large range HELP
Hello, I am having trouble with getting my formula to work. I need it to count the number of dates that fall within 1/1/2018 to 1/31/2018 only if they are in the column name "Actual" This is what...
Sorry, it was misprint in formula
=SUMPRODUCT(ISNUMBER(SEARCH("Actual",$R$3:$BA$3))*(R4:BA25>=DATEVALUE("2018-01-01"))*(R4:BA25<=DATEVALUE("2018-01-31")))
Hi Tyler,
That could be
=SUMPRODUCT(ISNUMBER(SEARCH("Actual",$R$3:$BA$3))*(R4:BA25>=DATEVALUE("1/1/2018")*(R4:BA25<=DATEVALUE("1/31/2018"))))
With COUNTIFS ranges shall be of the same size
This seems to be working to find any dates within January of 2018 but it doesn't seem to be looking at only the column name "Actual".
Sorry, it was misprint in formula
=SUMPRODUCT(ISNUMBER(SEARCH("Actual",$R$3:$BA$3))*(R4:BA25>=DATEVALUE("2018-01-01"))*(R4:BA25<=DATEVALUE("2018-01-31")))Thank you so much for all the help! That works great!!