LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 8,651
Default networkdays function

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Networkdays function jeanmac Excel Worksheet Functions 3 July 14th 07 01:42 PM
Nesting Networkdays function inside and If function Addison Excel Worksheet Functions 2 April 13th 06 08:04 PM
NETWORKDAYS FUNCTION, Help please BiggyTwo Excel Worksheet Functions 9 March 30th 06 02:36 AM
Networkdays function Susan Hayes Excel Worksheet Functions 2 April 5th 05 06:59 PM
Nested IF Function, Date Comparing, and NetworkDays Function carl Excel Worksheet Functions 2 December 29th 04 09:57 PM


All times are GMT +1. The time now is 01:58 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"