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

G

Guest

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)
 
G

Guest

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
workday formula question 3
Add no. of days to a workday to get new workday? 1
format a cell with a formula so an empty reference cell shows blan 3
In WORKDAY function, how to exclude multiple/variable holiday rang 4
Workday Error #VALUE! 4
Help with MACRO to Edit WORKDAY Formula? 2

Top