Home |
Search |
Today's Posts |
#6
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Yes, that sounds much simpler, Ron.
-- David Biddulph "Ron Rosenfeld" wrote in message ... On Tue, 15 Jan 2008 22:02:44 -0000, "David Biddulph" <groups [at] biddulph.org.uk wrote: If you know that the end days are not weekend dates, then just subtract 2 from the NETWORKDAYS result. If the end days might be weekend dates, you'll need to test them (with the WEEKDAY function), and then subtract as appropriate. -- David Biddulph Or, he can just add one to the start date, and subtract one from the end date --ron |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Networkdays function | Excel Worksheet Functions | |||
Nesting Networkdays function inside and If function | Excel Worksheet Functions | |||
NETWORKDAYS FUNCTION, Help please | Excel Worksheet Functions | |||
Networkdays function | Excel Worksheet Functions | |||
Nested IF Function, Date Comparing, and NetworkDays Function | Excel Worksheet Functions |