LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 10,593
Default NETWORKDAYS function?

Use WORKDAY

=WORKDAY(start_date,days, holidays)

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Darin" wrote in message
ups.com...
Ok.. I am going nuts trying to figure this one out. I can find all
kinds of info on how to compute the networkdays (M-F) between two known
dates in Excel, but what I need to do is compute X workdays from a
known date to resolve a date.

For example in column Z I want to put in a date, say 06/22/2006 and I
want to add 7 workdays to that date and have the result placed in the
corresponding row of column B in mm/dd/yyyy format.

Is there any way of doing this? Am I trying to use the wrong function?



 
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 whahappened... Excel Worksheet Functions 6 January 15th 08 11:06 PM
Nesting Networkdays function inside and If function Addison Excel Worksheet Functions 2 April 13th 06 08:04 PM
networkdays function help Deb Bagby Excel Worksheet Functions 3 November 1st 05 05:36 PM
NETWORKDAYS FUNCTION Welby Excel Programming 0 October 5th 05 08:09 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 05:07 AM.

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"