LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #2   Report Post  
Frank Kabel
 
Posts: n/a
Default

Hi
use WORKDAY for this

Note: You have to install the Analysis toolpak Addin for this function

--
Regards
Frank Kabel
Frankfurt, Germany

"Chris Maximus" <Chris schrieb im
Newsbeitrag ...
I want to have a spreadsheet where I add a workday number to a date

and get
the end date, like MS Project. What formula would I use to get the

result to
show the duration as wrok days?


 
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
Adding hours to a date Rich Excel Worksheet Functions 6 November 28th 06 08:50 PM
Adding + in front of a number Ted Metro Excel Discussion (Misc queries) 3 December 29th 04 10:45 PM
Conditional Formatting (Date vs Number) [email protected] Excel Discussion (Misc queries) 7 December 20th 04 10:23 PM
Use Julian Date To Create Serial Number antho10359 Excel Discussion (Misc queries) 4 December 9th 04 01:50 AM
Returning the Week Number of a Specific Date on a Month arjcvg Excel Worksheet Functions 1 November 3rd 04 04:35 AM


All times are GMT +1. The time now is 12:01 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"