| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I calculate the number of business days?
Nelson, If the formula returns the #NAME? error then you need to install the analysis toolpak for the NETWORKDAYS function to work. Go to ToolsAddins and check the Analysis ToolPak option. Click ok. You also need to identify the federal holidays in your formula. Type in the holidays in a range say D1:D5 and then your formula should look like: =NETWORKDAYS(A2,B2,$D$1:$D$5) HTH Steve -- SteveG ------------------------------------------------------------------------ SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571 View this thread: http://www.excelforum.com/showthread...hreadid=547163 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Number of days left in the Month? | Excel Discussion (Misc queries) | |||
| Calculate Number of Days Between Dates Minus Weekends | Excel Discussion (Misc queries) | |||
| Number of Days in the Month | Excel Discussion (Misc queries) | |||
| Calculate number of days in a column of dates | Excel Discussion (Misc queries) | |||
| Count number of days in given month? | Excel Worksheet Functions | |||
Threaded Mode
