Help required for "between" dates formula

[Dave T]

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

 

[VBA Noob]

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

 

[Dave T]

Many thanks
Dave T

 

[Ron Rosenfeld]

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