need help please

[Wayne]

I wish to count the entries in a column (G) of dates that fall within a calendar quarter ie 04/01/03 and 06/30/03
I tried many formulas such as this one (none work) =COUNTIFand(G14:G238,"=>04/01/03,=<06/30/03") which returns
"#NAME?" some I've tried returned zero. Can anyone help with this? Thanks.

 

[JE McGimpsey]

One way:

=SUMPRODUCT(--(G14:G238>=DATE(2003,4,1)),--(G14:G238<=DATE(2003,6,30)))

Another:

=COUNTIF(G14:G238,">=4/1/2003") - COUNTIF(G14:G238,">6/30/2003")

 

[Michael J. Malinsky]

Have you tried:

=COUNT(G14:G238)

or

=COUNTA(G14:G238)

The difference is that COUNT counts numbers. So if your dates are not in
text format, it should work. COUNTA counts all cells in the range. Both
ignore empty cells.

HTH
Mike.

--
Michael J. Malinsky

I wish to count the entries in a column (G) of dates that fall within a

calendar quarter ie 04/01/03 and 06/30/03.

I tried many formulas such as this one (none work)

=COUNTIFand(G14:G238,"=>04/01/03,=<06/30/03") which returns