Thread: How to count dates in a column between 2 dates
View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.programming
merjet merjet is offline
external usenet poster
  
Posts: 812
Default How to count dates in a column between 2 dates
Here is another formula:
=SUMPRODUCT(($AL$1000:$AL$5000<=TODAY())*($AL$1000 :$AL
$5000=EDATE(TODAY(),-3)))

Hth,
Merjet

Reply With QuoteReply With Quote