count between dates

Originally Posted by Jymoz

is there a way to do some kind of count between two dates

heres what i have:

i have transactions and the dates they were on, now i want to make a table showingthe number of transactions per month. i thought of doing a count between the beginning of one month and the beginning of the next but it wont work.

if you can tell how to do this, using my method or something else i would be very grateful

What sort of table, and why won't it work?

ie, in Rows 1-12

=COUNT(IF(MONTH(B$1:B$100)=ROW(),1))-IF(ROW()=1,COUNTBLANK(B$1:B$100),0)

works for me.
---

Originally Posted by Jymoz

the table is in the form:

Customer number/item Code/Date Out/Date in

the dates are in the form mm/dd/yyyy and i think it may be the dates that are the problem, but i'm not sure. In the formula the date comes up as a number like 38975

38975 is a natural form for a date of 15/Sep/2006, did the Countif work?

---

Originally Posted by Jymoz

yeah i got it working now

thanks for your help

good to see, and thanks for your response.
---