Thread: How to Count Months in a Column of Dates
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
daddylonglegs[_4_] daddylonglegs[_4_] is offline
external usenet poster
  
Posts: 1
Default How to Count Months in a Column of Dates

Don't know about VBA but you could count the number of dates which fal
within a specific month and year using a single formula, e.g. for Apri
2006

=SUMPRODUCT(--(MONTH(contactResults)=4),--(YEAR(contactResults)=2006)

--
daddylongleg
-----------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...fo&userid=3048
View this thread: http://www.excelforum.com/showthread.php?threadid=50632

Reply With QuoteReply With Quote