Thread: networkdays function
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mike H[_3_] Mike H[_3_] is offline
external usenet poster
  
Posts: 39
Default networkdays function
Try

=NETWORKDAYS(A1+1,A2+1,Holidays+1)

A1= start date
A2= End date
Holidays is a named range

Mike

On Dec 27, 5:00*am, Medo wrote:
I need to set the weekend days to Friday & Saturday instead of Saturday &
Sunday in Excel.

Reply With QuoteReply With Quote