Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
networkdays problem
Hi. I have the following formula which calculates work days with non-Sat/Sun weekends. The problem I am having is that for excluding holidays it still works as if it is Sat/Sun weekends. Could anyone help me out with a solution. =(NETWORKDAYS(C48+3,F48+3,S$38:S$66))-(INT((((F48+4)-(C48+4))-MOD(7-(C48+4),7))/7)+1) Thanks. -- goober ------------------------------------------------------------------------ goober's Profile: http://www.excelforum.com/member.php...o&userid=19838 View this thread: http://www.excelforum.com/showthread...hreadid=495485 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
networkdays problem
On Thu, 22 Dec 2005 07:44:12 -0600, goober
wrote: Hi. I have the following formula which calculates work days with non-Sat/Sun weekends. The problem I am having is that for excluding holidays it still works as if it is Sat/Sun weekends. Could anyone help me out with a solution. =(NETWORKDAYS(C48+3,F48+3,S$38:S$66))-(INT((((F48+4)-(C48+4))-MOD(7-(C48+4),7))/7)+1) Thanks. If your weekend days are "two" and are contiguous, then you just need to add an appropriate offset to start_date, end_date, and holiday_dates. You may not be adding the appropriate offset to holiday_dates in your formula. If you have some other criteria for weekend dates, then I can post a UDF that is more flexible. --ron |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
networkdays problem
Thank you Ron. An offset fixed the issue I was having. I didn't realize that it would be that simple of a fix. Your help is greatly appreciated. -- goober ------------------------------------------------------------------------ goober's Profile: http://www.excelforum.com/member.php...o&userid=19838 View this thread: http://www.excelforum.com/showthread...hreadid=495485 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
networkdays problem
On Thu, 22 Dec 2005 20:43:09 -0600, goober
wrote: Thank you Ron. An offset fixed the issue I was having. I didn't realize that it would be that simple of a fix. Your help is greatly appreciated. Thanks for the feedback. I'm glad I was able to help. Best wishes, --ron |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Urgent Help Required on Excel Macro Problem | Excel Discussion (Misc queries) | |||
Problem With Reference Update | Excel Worksheet Functions | |||
Copy an Drag cell Formula Problem | Excel Discussion (Misc queries) | |||
problem office assistant | Excel Discussion (Misc queries) | |||
Freeze Pane problem in shared workbooks | Excel Discussion (Misc queries) |