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

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

Guest

The NETWORKDAYS function regards Saturday and Sunday as weekends. I need to
set Excel to regard Friday and Saturday as the weekend.
 
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
 
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...
 
Back
Top