Thread: Number of Saturdays within a range of dates
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
vezerid vezerid is offline
external usenet poster
  
Posts: 751
Default Number of Saturdays within a range of dates
On May 30, 5:55 pm, Ruben wrote:
What, if any, formula can I use to count the number of Saturdays between 2
dates?
Thanks!

Start date in D1, End date in D2:
=SUMPRODUCT(--(WEEKDAY(ROW(INDIRECT(D1&":"&D2)))=7))

HTH
Kostis Vezerides

Reply With QuoteReply With Quote