Thread: How do I change weekends from Sat, Sun to Fri, Sat in networkdays
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ashish Mathur[_2_] Ashish Mathur[_2_] is offline
external usenet poster
  
Posts: 1,766
Default How do I change weekends from Sat, Sun to Fri, Sat in networkdays
Hi,

Try this

=SUMPRODUCT(1*(WEEKDAY(ROW(INDIRECT(C5&":"&C6)))<6 ))

C5 holds the beg date and C6 holds the ending date

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Suresh" wrote in message
...
I want to use the Networkdays function to get the working days between two
dates. But in my case I want to make Firday and Saturday as weekend rather
than Saturday and Sunday. Is it possible.

Thanks!

Reply With QuoteReply With Quote