LinkBack URL
About LinkBacks
the normal format for countifs between dates is:
=COUNTIFS(Data range,">="&Cell containing start date,Data range,"<="&Cell containing end date)
e.g.
=COUNTIFS(A1:A100,">="&B1,A1:A100,"<="&B2)
not sure if this helps...
the normal format for countifs between dates is:
=COUNTIFS(Data range,">="&Cell containing start date,Data range,"<="&Cell containing end date)
e.g.
=COUNTIFS(A1:A100,">="&B1,A1:A100,"<="&B2)
not sure if this helps...
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU
I like the solution you have provided Glenn, but I don't think it will work in my scenario. The reason I say this is because my dates are looking at a range of dates after converting it to a number.
Basically I am only extracting the month number and not the full date.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks