| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I set NETWORKDAYS to regard friday and saturday as weekend
The NETWORKDAYS function regards Saturday and Sunday as weekends. I need to
set Excel to regard Friday and Saturday as the weekend. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I set NETWORKDAYS to regard friday and saturday as 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 "Shay.C." wrote in message ... The NETWORKDAYS function regards Saturday and Sunday as weekends. I need to set Excel to regard Friday and Saturday as the weekend. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I set NETWORKDAYS to regard friday and saturday as week
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." wrote in message ... The NETWORKDAYS function regards Saturday and Sunday as weekends. I need to set Excel to regard Friday and Saturday as the weekend. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Date Calculations | Excel Worksheet Functions | |||
| Starting work period on a Saturday and ending on a friday | Excel Worksheet Functions | |||
| Starting work period on a Saturday and ending on a friday | Excel Discussion (Misc queries) | |||
Hybrid Mode
