networkdays function
 

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

networkdays function
 

Try

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

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

Mike

On Dec 27, 5:00*am, Medo wrote:
I need to set the weekend days to Friday & Saturday instead of Saturday &
Sunday in Excel.

networkdays function
 

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

On Dec 27, 5:28*am, Mike H wrote:
Try

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

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

Mike

On Dec 27, 5:00*am, Medo wrote:



I need to set the weekend days to Friday & Saturday instead of Saturday &
Sunday in Excel.- Hide quoted text -

- Show quoted text -

networkdays function
 

Try:

=NETWORKDAYS(<start date+1, <end date+1)

In article ,
Medo wrote:

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

networkdays function
 

As NETWORKDAYS needs the installation of an add-in, maybe have a look at
'this site' (http://www.cpearson.com/excel/betternetworkdays.aspx)


--
Pecoflyer

Cheers -
*_Membership_is_free_* & allows file upload -faster and better answers
------------------------------------------------------------------------
Pecoflyer's Profile: http://www.thecodecage.com/forumz/member.php?userid=14
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=44313