Counting between 2 dates

[andrewc]

Hi,

I am trying to count the number of observations between two dates, named as start_date and end_date. The values to count are in column B in a range named fund_returns and the associated dates are in a range in column A named dates.

The start_date is 31/10/2007 and the end_date is 31/10/2010 so there should be 36 monthly observations counted by my formula between those dates:

{=COUNT(IF(dates>start_date,dates<=end_date,fund_returns))}

However, this formula counts only 24 items. Can someone please suggest what I’m doing wrong.

Thanks!

[NBVC]

If you are using 2007:

=SUMIFS(fund_returns,dates,">"&start_date,dates,"<="&end_date)

or in all versions:

=SUMIF(dates,">"&start_date,fund_returns)-SUMIF(dates,">"&end_date,fund_returns)