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

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - How do I create a formula to add 10 workdays to a specified date . (https://www.excelbanter.com/excel-discussion-misc-queries/49597-how-do-i-create-formula-add-10-workdays-specified-date.html)

Dallas7905

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!

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)

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

Dallas7905

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

All times are GMT +1. The time now is 03:20 PM.