Date range calc

  • Thread starter Thread starter Joel Griffith
  • Start date Start date
J

Joel Griffith

Hi I was wondering if anyone could help with this problem
i am having?

I have spreadsheet that has a list of companies names and
in the next colum where I put the date in which it was
recieved. I have 12 sheet for 12 months.

For examaple when I get a report in december from one of
the companies I enter it in I enter the date it was
recieved.

Once I enter the date. I want it to count that it has
been recieved for December.

If the cell is blank I want it to count has not recieved.

The formula i have tried is as follows

=countif(A1:A4, Between "01/12/03 and 31/12/03")

Please help thanks Joel
 
Joel Griffith said:
Hi I was wondering if anyone could help with this problem
i am having?

I have spreadsheet that has a list of companies names and
in the next colum where I put the date in which it was
recieved. I have 12 sheet for 12 months.

For examaple when I get a report in december from one of
the companies I enter it in I enter the date it was
recieved.

Once I enter the date. I want it to count that it has
been recieved for December.

If the cell is blank I want it to count has not recieved.

The formula i have tried is as follows

=countif(A1:A4, Between "01/12/03 and 31/12/03")

Please help thanks Joel
Click to expand...

Try either
=SUMPRODUCT((A1:A4>=DATE(2003,12,1))*(A1:A4<=DATE(2003,12,31)))
or
=SUMPRODUCT((YEAR(A1:A4)=2003)*(MONTH(A1:A4)=12))
 
Dear Paul Many thanks for your hel but I still ge a value
error from what was suggested, do you have any Idea why

Joel
 
Back
Top