| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How do I create a formula to add 10 workdays to a specified date .
I want to add 10 workdays to a specified date. The formula I have used in
the past was =WORKDAY(A2,10), but for some reason I keep getting the #NAME? error when I try to use it now. How can I eliminate or fix this error? I've tried everything! |
|
#2
|
|||
|
|||
|
Make sure you have the analysis toolpak loaded.
Tools|Addins (you may need your distribution CD if that analysis toolpak isn't installed) Dallas7905 wrote: I want to add 10 workdays to a specified date. The formula I have used in the past was =WORKDAY(A2,10), but for some reason I keep getting the #NAME? error when I try to use it now. How can I eliminate or fix this error? I've tried everything! -- Dave Peterson |
|
#3
|
|||
|
|||
|
Thanks Dave! My frustration is over...
"Dave Peterson" wrote: Make sure you have the analysis toolpak loaded. Tools|Addins (you may need your distribution CD if that analysis toolpak isn't installed) Dallas7905 wrote: I want to add 10 workdays to a specified date. The formula I have used in the past was =WORKDAY(A2,10), but for some reason I keep getting the #NAME? error when I try to use it now. How can I eliminate or fix this error? I've tried everything! -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I create a formula for Salutation | Excel Discussion (Misc queries) | |||
| Create Formula for calculating Little League Age... | Excel Worksheet Functions | |||
| How to create specific formula | Excel Worksheet Functions | |||
| How do I create a formula that would allow me to subtract from a d | New Users to Excel | |||
| How do I create a formula in Excel that will countif or sumif bef. | Excel Worksheet Functions | |||
Linear Mode
