Thread: Help on Dates
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Roger Govier Roger Govier is offline
external usenet poster
 
Posts: 2,886
Default Help on Dates

Hi Paul
With start date in A1 and end date in B1 try
=INT((B1-A1)/7)+OR(WEEKDAY(A1)=7,WEEKDAY(B1)=7)

--
Regards

Roger Govier


"Paulf" wrote in message
...
Hiya

Is there a way of calculating the number of Saturdays between two
dates in Excel?

Thanks in advance
Paul