Counting the number of date entries in a giving month

[Guest]

I have a very simple spreadsheet the records the date a document is created
and records dates in the documents history

what i was to do is counts the number of documents created by month so i can
put this information into a bar chart

eg if i have 200 dates in a column i want to know how many dates are in Jan,
Feb, March etc...

Hope this makes sense

Thanks in advance

Phil G

 

[Guest]

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

Dates in column A and month of January

If you have more than one year you can check year:

=SUMPRODUCT(--(MONTH(A1:A100)=1),--(YEAR(A1:A100)=2006))

HTH

 

[Guest]

Excelent that works

How do i get it to ignore the empty cells , eg if i have 82 entries in the
coloum A1:A200

Currently it reports the empty cells as Jan ?

 

[Guest]

Try the following modification:

=SUMPRODUCT(--(MONTH(A1:A100)=1)) - COUNTBLANK(A1:A100)

That should take care of blanks.

HTH,

TK

 

[Guest]

=SUMPRODUCT(--(MONTH(A1:A100)=1),--(A1:A100<>""))