counting dates

[scsag]

I'm trying to set a formula to count dates in a column by months. Such as,
the total number of dates in October, the total in November, etc. Any help?

 

[Frank Kabel]

Hi
try
=SUMPRODUCT(--(MONTH(A1:A100)=10),--(A1:A100<>""))

--
Regards
Frank Kabel
Frankfurt, Germany

I'm trying to set a formula to count dates in a column by months. Such as,
the total number of dates in October, the total in November, etc.

Any help?

 

[Sandy Mann]

Frank,

May I ask why you added the

--(A1:A100<>"")

=SUMPRODUCT(--(MONTH(A1:A100)=10))

seems to work for me and it ignores blanks. Both formulas return #VALUE! if
any cell contains text.

Just curious

Sandy

 

[Frank Kabel]

Hi
if you search for October no need for it but if you would search for
January (1) the formula would count empty cells as well (as a blank
cell is the same as the date '00-Jan-1900')

Try this with the formula
=MONTH(A1)
then A1 is empty. It will return '1'

 

[Sandy Mann]

Thank you Frank, you are of course quite right.

Regards

Sandy