How do I set NETWORKDAYS to regard friday and saturday as weekend

S

Shay.C.

The NETWORKDAYS function regards Saturday and Sunday as weekends. I need to
set Excel to regard Friday and Saturday as the weekend.
 
B

Biff

Hi!

Try this:

A1 = start date
A2 = end date

=NETWORKDAYS(A1+1,A2+1)

If you need to exclude holidays:

H1:H10 = list of holiday dates

Entered as an array using the key combination of CTRL,SHIFT,ENTER.

=NETWORKDAYS(A1+1,A2+1,H1:H10+1)

Biff
 
S

Sadad

PERFECT... IT WORKS :)

Thanks you...

Biff said:
Hi!

Try this:

A1 = start date
A2 = end date

=NETWORKDAYS(A1+1,A2+1)

If you need to exclude holidays:

H1:H10 = list of holiday dates

Entered as an array using the key combination of CTRL,SHIFT,ENTER.

=NETWORKDAYS(A1+1,A2+1,H1:H10+1)

Biff
Click to expand...
 

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 to implement two shifts per day with multiple teams 0
Friday as weekend instead of Saturday & Sunday 3
Friday as weekend in Workday Function 6
How do I change weekends from Sat, Sun to Fri, Sat in networkdays 3
networkdays function 4
Change the weekends 1
How to calculate the number of Workdays for irregular work pattern 1
Calculate workdays for irregular work patterns 1

Top