Thread: Help on Dates
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Paulf Paulf is offline
external usenet poster
 
Posts: 3
Default Help on Dates

Many Thanks Roger!

"Roger Govier" wrote in message
...
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