excel get date period were value appears? -

excel get date period were value appears? -

i trying date period using excel formula

=countif(rawdata!d5:d10004,b8)&" - " &text( iferror(index(rawdata!g5:g10004,match("*"&'summary of spend_1'!b8&"*",rawdata!d5:d10004,0)),"no details held"),"dddd mmmm dd,yyyy")

i want count how many times value found in columns , match minimum , maximum date.

for instance supplier have been invoiced on 1st september 2014 , 5th september 2014, , lastly invoice 25th september 2014.

so how supplier had 11 invoices raised between 1st september , 25th september?

thanks

let's assume date column a:a, minimum date in cell b1, maximum - in cell c1:

=countifs($a:$a,">="&$b$1,$a:$a,"<="&$c$1)

excel date