How do I create a formula to add 10 workdays to a specified date .

D

Dallas7905

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!
 
D

Dave Peterson

Make sure you have the analysis toolpak loaded.

Tools|Addins

(you may need your distribution CD if that analysis toolpak isn't installed)
 
D

Dallas7905

Thanks Dave! My frustration is over...

Dave Peterson said:
Make sure you have the analysis toolpak loaded.

Tools|Addins

(you may need your distribution CD if that analysis toolpak isn't installed)
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to shift a weekend date to the last or next workday 2
Adding weekdays in a date formula 2
Add no. of days to a workday to get new workday? 1
Create Range by joining multiple Ranges - passing multiple holidayranges to Workday function 6
workday formula question 3
In WORKDAY function, how to exclude multiple/variable holiday rang 4
WORKDAY Function 3
how do i create a formula to give a workday date? 2

Top