Thread: Count Weekend Days solutions thank you very much to both of you
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Domenic Domenic is offline
external usenet poster
  
Posts: 256
Default Count Weekend Days solutions thank you very much to both of you
To count the number of Saturdays and Sundays...

=SUMPRODUCT(--(WEEKDAY(ROW(INDIRECT(A2&":"&B2)),2)5))

....where A2 contains the start date, and B2 contains the end date.

Hope this helps!

In article ,
koob wrote:
Reply With QuoteReply With Quote