I am by no means am I an Excel formula expert. I have been struggling with this formula for 3 days, looking all over google and everything says it is right but it returns 0 when it should return 145.
I am trying to count how many line entry dates fall with fall within a specified date range based upon weather it is Scheduled or Unscheduled. I have not gotten to the "Scheduled or Unscheduled" in the formula, since i cant get just a basic count to work.
the Formula i am using is: =COUNTIFS(AL5:AL5000, ">="&DATE(AA2,6,20), AL5:AL5000, "<="&DATE(AF2,6,25)) This should be looking at all dates that fall between the range of AA2 and AF2 in column AL. but as i said the return is 0.
Any and all help is greatly appreciated, Thank You in advance
I am trying to count how many line entry dates fall with fall within a specified date range based upon weather it is Scheduled or Unscheduled. I have not gotten to the "Scheduled or Unscheduled" in the formula, since i cant get just a basic count to work.
the Formula i am using is: =COUNTIFS(AL5:AL5000, ">="&DATE(AA2,6,20), AL5:AL5000, "<="&DATE(AF2,6,25)) This should be looking at all dates that fall between the range of AA2 and AF2 in column AL. but as i said the return is 0.
Any and all help is greatly appreciated, Thank You in advance