View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
daddylonglegs daddylonglegs is offline
external usenet poster
 
Posts: 287
Default 6 day/week function ie:networkday

or just

=INT((WEEKDAY(A1)+B1-A1)/7)

"RyGuy" wrote:

Try this:
=NETWORKDAYS((A1),(A2))+INT((A2-WEEKDAY(A2-6)-A1+8)/7)




"Robert" wrote:

i am trying to calculate how many days between 2 dates that excludes
holidays, but includes saturdays. Networkdays is only for 5 day work
weeks...i need it to be for 6 day work weeks.