While using networkdays function, how can define weekly off days

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Excel count weekly off Saturday & Friday. But my case it is Friday &
Saturday. I want to define that while using networkdays and workday functions.

Please help.

Regards
 
I think you mean that the days off should be Friday and Saturday, not
Saturday and Sunday, if so then use

=NETWORKDAYS(start_date+1,end_date+1)

--
HTH

Bob Phillips

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Changing working days 6
How to calculate the number of Workdays for irregular work pattern 1
Calculate workdays for irregular work patterns 1
Change the weekends 1
count work days excluding Fridays and Saturdays ??? 3
How do I use the WORKDAY function for a six-day working week? 12
How do I change weekends from Sat, Sun to Fri, Sat in networkdays 3
WOrkday function - change working days 2

Back
Top