=countif(a1:a10,"="&date(2005,1,1)) - countif(a1:a10,""&date(2005,1,3))

(I'm not sure what between means--include the end dates or not???)

joe wrote:

example
1/1/2005
1/2/2005 = 2
2/1/2005
2/2/2005 = 2

I am trying to get the ount if the value is between 1/12005 and 1/3/2005 and
similarly 2/1/2005 and 2/3/2005

--

Dave Peterson