Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
networkdays function
I need to set the weekend days to Friday & Saturday instead of Saturday &
Sunday in Excel. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 - |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Nesting Networkdays function inside and If function | Excel Worksheet Functions | |||
NETWORKDAYS FUNCTION, Help please | Excel Worksheet Functions | |||
networkdays function help | Excel Worksheet Functions | |||
Function "Networkdays" | Excel Worksheet Functions | |||
Nested IF Function, Date Comparing, and NetworkDays Function | Excel Worksheet Functions |