Hi

I have a column of dates in my spreadsheet database and I am trying to
extract data for each month. In an Access database the formula "between"
can be used, however, not in Excel. Could anyone help with this formaula
please such as,

COUNTIF(Date from & to, A2)

Thankyou for your anticiapted help.

Dave T

Try something like this

Just change your range. Also you can swap the dates I put in to look at
a cell ref.

=SUMPRODUCT(--($A$19:$A$27=--"01/07/2006"),--($A$19:$A$27<=--"31/07/2006"))

More help can be found on

http://www.xldynamic.com/source/xld.SUMPRODUCT.html

VBA Noob


--
VBA Noob
------------------------------------------------------------------------
VBA Noob's Profile: http://www.excelforum.com/member.php...o&userid=33833
View this thread: http://www.excelforum.com/showthread...hreadid=568725

Many thanks
Dave T

"VBA Noob" wrote in
message ...

Try something like this

Just change your range. Also you can swap the dates I put in to look at
a cell ref.

=SUMPRODUCT(--($A$19:$A$27=--"01/07/2006"),--($A$19:$A$27<=--"31/07/2006"))

More help can be found on

http://www.xldynamic.com/source/xld.SUMPRODUCT.html

VBA Noob


--
VBA Noob
------------------------------------------------------------------------
VBA Noob's Profile:
http://www.excelforum.com/member.php...o&userid=33833
View this thread: http://www.excelforum.com/showthread...hreadid=568725

On Sun, 06 Aug 2006 08:42:58 GMT, "Dave T" wrote:

Hi

I have a column of dates in my spreadsheet database and I am trying to
extract data for each month. In an Access database the formula "between"
can be used, however, not in Excel. Could anyone help with this formaula
please such as,

COUNTIF(Date from & to, A2)

Thankyou for your anticiapted help.

Dave T


One way, using COUNTIF:

=COUNTIF(range,"="&start_date) - COUNTIF(range,""&end_date)


--ron