| Home | Forums | Reviews | Articles | Register |
 |
| Thread Tools | Rate Thread |
|
Guest
Posts: n/a
|
|
|
|
||
|
|
| |
|
Guest
Posts: n/a
|
|
|
|
|
||
|
Guest
Posts: n/a
|
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. > > > |
|
|
|
|
|||
|
|
| |
|
| Thread Tools | |
| Rate This Thread | |
|
|
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 |
