networkdays function

M

Medo

I need to set the weekend days to Friday & Saturday instead of Saturday &
Sunday in Excel.
 
M

Mike H

Try

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

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

Mike
 
M

Mike H

Forgot to mention, it's now an array formula

'This is an array formula which must be entered with CTRL+Shift+Enter
and NOT
'just enter. If you do it correctly then Excel will put curly brackets
around
'the formula{}. You can't type these yourself. If you Edit the ranges
'then you must re-enter as An array

Mike
 

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

How do I change weekends from Sat, Sun to Fri, Sat in networkdays 3
How do I set NETWORKDAYS to regard friday and saturday as weekend 2
Friday as weekend instead of Saturday & Sunday 3
Friday as weekend in Workday Function 6
Change the weekends 1
Calculate workdays for irregular work patterns 1
How to calculate the number of Workdays for irregular work pattern 1
Modify the official None-working days in the "NETWORKDAYS" Functio 3

Top