View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bob Phillips Bob Phillips is offline
external usenet poster
 
Posts: 10,593
Default WOrkday function - change working days

=WORKDAY(start_date,days)-SUMPRODUCT(--(WEEKDAY(ROW(INDEX($1:$65536,start_da
te,1):INDEX($1:$65536,WORKDAY(start_date,days),1)) )=1))

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Ashutosh" wrote in message
...
How do I define working days as Monday to Saturday for the Workday

function ?
( instead of standard Monday to Friday