Thread: '08-'11 Days of the Wk per Month
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Jarek Kujawa[_2_] Jarek Kujawa[_2_] is offline
external usenet poster
  
Posts: 896
Default '08-'11 Days of the Wk per Month
B1=6/29/09
B2=8/16/09
$A$1:$A$40 includes yr dates

=SUM(IF((WEEKDAY($A$1:$A$40,2)=1)*($A$1:$A$40=B1) *($A$1:$A$40<=B2),
1,0))

the result is 6 (in my Excel 2003)

array-enter the formula i.e. CTRL+SHIFT+ENTER

HIH
Reply With QuoteReply With Quote