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

Thank you very much. This did exactly what i needed it to.

"Toppers" wrote:

This calculates number of Saturdays in a period so add this to NETWORKDAYS:

=SUMPRODUCT(--(WEEKDAY(ROW(INDIRECT(A1&":"&B1)))=7))

A1=Start date
B1=End date

"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.