View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Daniel.M Daniel.M is offline
external usenet poster
 
Posts: 32
Default Number of Saturdays within a range of dates

Hi Ruben,

With
A1=Start Date and
A2=End Date,

=INT((A2-WEEKDAY(A2-6)-A1+8)/7)

Regards,

Daniel M.

"Ruben" wrote in message
...
What, if any, formula can I use to count the number of Saturdays between 2
dates?
Thanks!