countif
 

Can anyone help please!!!
I need to count the occurences of date vales (non specific) between the 1st
and 31st of each month. Dates are posted in a column and the name range
called Presentations.
So far I have
tried:countif(presentations,and("="&"1/3/2008","<="&"31/3/2008")). The
result has to state how many presentations occured between the dates
specified. The only other way was to break it down to weekly occurences
(multiple countif) and them sum them.
Majestyk

countif
 

This would do the same thing:

=SUMPRODUCT(--(MONTH(presentations)=1))

Change the month to 2 for February.

--
"Actually, I *am* a rocket scientist." -- JB

Your feedback is appreciated, click YES if this post helped you.


"majestyk" wrote:

Can anyone help please!!!
I need to count the occurences of date vales (non specific) between the 1st
and 31st of each month. Dates are posted in a column and the name range
called Presentations.
So far I have
tried:countif(presentations,and("="&"1/3/2008","<="&"31/3/2008")). The
result has to state how many presentations occured between the dates
specified. The only other way was to break it down to weekly occurences
(multiple countif) and them sum them.
Majestyk

countif
 

If its for dates falling within a certain month/year:
=SUMPRODUCT(--(TEXT(presentations,"mmmyyyy")="Mar2008"))

If its for a certain date range which may straddle across months,
then something unambiguous like this:
=SUMPRODUCT((presentations=--"1 Feb 2008")*(presentations<=--"15 Mar 2008"))

Real dates are presumed within the defined range: presentations

Pl mark responses which help by clicking the YES buttons below
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:23,000 Files:370 Subscribers:66
xdemechanik
---
"majestyk" wrote:
I need to count the occurences of date vales (non specific) between the 1st
and 31st of each month. Dates are posted in a column and the name range
called Presentations.
So far I have
tried:countif(presentations,and("="&"1/3/2008","<="&"31/3/2008")). The
result has to state how many presentations occured between the dates
specified. The only other way was to break it down to weekly occurences
(multiple countif) and them sum them