PC Review


Reply
Thread Tools Rate Thread

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

 
 
=?Utf-8?B?U2hheS5DLg==?=
Guest
Posts: n/a
 
      9th Jul 2006
The NETWORKDAYS function regards Saturday and Sunday as weekends. I need to
set Excel to regard Friday and Saturday as the weekend.
 
Reply With Quote
 
 
 
 
Biff
Guest
Posts: n/a
 
      9th Jul 2006
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

"Shay.C." <Shay.C.@discussions.microsoft.com> wrote in message
news:8A9FBEA5-9E73-485A-9CB8-(E-Mail Removed)...
> The NETWORKDAYS function regards Saturday and Sunday as weekends. I need
> to
> set Excel to regard Friday and Saturday as the weekend.



 
Reply With Quote
 
Sadad
Guest
Posts: n/a
 
      13th Apr 2010
PERFECT... IT WORKS

Thanks you...

"Biff" wrote:

> 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
>
> "Shay.C." <Shay.C.@discussions.microsoft.com> wrote in message
> news:8A9FBEA5-9E73-485A-9CB8-(E-Mail Removed)...
> > The NETWORKDAYS function regards Saturday and Sunday as weekends. I need
> > to
> > set Excel to regard Friday and Saturday as the weekend.

>
>
>

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Friday as weekend instead of Saturday & Sunday Naushad Microsoft Excel Worksheet Functions 3 14th Mar 2009 08:22 AM
Networkdays including Saturday? phil.evans@bowiecastlebank.com Microsoft Excel Worksheet Functions 5 17th Jun 2008 02:59 PM
Networkdays include weekend day if activity Suzanne Microsoft Excel Misc 3 13th Jun 2008 06:48 PM
Re: Cell colour chg when formula results equal a weekend day, i.e., "Saturday" and a date that falls on a Saturday? StargateFan Microsoft Excel Programming 0 19th Sep 2005 01:09 PM
how do i show Friday and saturday as the weekend days? =?Utf-8?B?QWxp?= Microsoft Outlook Calendar 2 7th Nov 2004 01:34 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 03:41 PM.