0 return when using Countifs statement

[nelmagene]

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

 

[FormR]

=COUNTIFS(AL5:AL5000, ">="&DATE(AA2,6,20), AL5:AL5000, "<="&DATE(AF2,6,25))

Hi, you don't need the DATE() function as you already have the full date in AA2 and AF2 and the DATE() function returns a date from it's parts.
i.e.

=COUNTIFS(AL5:AL5000, ">="&AA2, AL5:AL5000, "<="&AF2)

 

[nelmagene]

Hi, you don't need the DATE() function as you already have the full date in AA2 and AF2 and the DATE() function returns a date from it's parts.
i.e.

=COUNTIFS(AL5:AL5000, ">="&AA2, AL5:AL5000, "<="&AF2)

Thank You so much, it works. I have never been happier to feel like a dumb fellow.. Your are great!!!!!!!!!!!!!!!!!!