Thread: calculate how many sundays between two dates in excel
View Single Post
  #2   Report Post  
Bernd Plumhoff
 
Posts: n/a
Default
Hi Jeff,

=SUM(--(WEEKDAY(ROW(INDIRECT(A1&":"&A2)))=1))

array-entered

HTH,
Bernd
Reply With QuoteReply With Quote