Sounds like the dates are not real dates

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Bugaglugs" wrote in message
...
Bob - spot on, I'm getting a '0' which I can't see the reason for!

"Bob Phillips" wrote:

If they are dates, the format should not matter at all.

What problems are you experiencing? Do you get 0 or an answer which you
can't see the reason for?

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Bugaglugs" wrote in message
...
Bob - thanks for you prompt response - I'm still having problems, do
you
think it's how I've formatted the cells with the dates in? I've got
them
so
that however the user inputs the date it comes up "01-Apr-05" format?

"Bob Phillips" wrote:



=SUMPRODUCT(--(A2:A1000=DATE(2005,04,01)),--(A2:A1000<=DATE(2005,04,20))

If you are just looking for a month, you can use

=SUMPRODUCT(--(MONTH(A2:A1000)=4))

or if there can be multiple yers, then

=SUMPRODUCT(--(YEAR(A2:A1000)=2005),--(MONTH(A2:A1000)=4))

or

=SUMPRODUCT(--(TEXT(A2:A1000,"yyyymm")="200504")

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Bugaglugs" wrote in message
...
In column A I have dates in the following format;
01-Apr-05 right through until the end of March 2006
On a different sheet in my workbook I want to summarise the
information
by
counting the number of appointments between certain dates to get
monthly
totals. I just don't know how to say that I want all dates
between
01-Apr-05
until say 30-Apr-05p and so on. Is it possible to do this - the
formula I
was trying with was;
=COUNT(IF('Master
Sheet'!$A$2:$A$10000=DATEVALUE("01/04/2005:30/04/2005"),1,0))
But this isn't working!