Help required for "between" dates formula
 

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

Help required for "between" dates formula
 

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

Help required for "between" dates formula
 

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

Help required for "between" dates formula
 

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