Counting cells within a date range

I need help counting how many cells contain dates in September within a row. HELP!

The simplest way is to use a helper column.

=IF(MONTH(A2)=9,1,0)

will return 1 if month i September

A sum function will then count how many cells contain 1.

Try this:

=COUNTIFS($1:$1,">="&DATE(2013,9,1),$1:$1,"<="&DATE(2013,9,30))

assuming your dates are in row 1.

Hope this helps.

Pete

GOT IT! Thank you so much!!!!

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

Thanks.

Pete