ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   how do you add in a new function? (https://www.excelbanter.com/excel-worksheet-functions/48022-how-do-you-add-new-function.html)

Jennifer Carver

how do you add in a new function?
 
I am trying to use the formula =NETWORKDAYS so that I can calculate the
dirrence between dates and the computer will knwo which holidays to take out.
However, I am using Office 2003 and it doesn't have that formula in it. How
can I add that into my office program?

Duke Carey

Use the Tools menu - go to Add-ins... and check Analysis Toolpak


"Jennifer Carver" wrote:

I am trying to use the formula =NETWORKDAYS so that I can calculate the
dirrence between dates and the computer will knwo which holidays to take out.
However, I am using Office 2003 and it doesn't have that formula in it. How
can I add that into my office program?


Jennifer Carver

Thank you so much. I needed to figure that out for a deadline today. The
advice worked great. Thanks again!!!!

"Duke Carey" wrote:

Use the Tools menu - go to Add-ins... and check Analysis Toolpak


"Jennifer Carver" wrote:

I am trying to use the formula =NETWORKDAYS so that I can calculate the
dirrence between dates and the computer will knwo which holidays to take out.
However, I am using Office 2003 and it doesn't have that formula in it. How
can I add that into my office program?


Duke Carey

Glad it helped

"Jennifer Carver" wrote:

Thank you so much. I needed to figure that out for a deadline today. The
advice worked great. Thanks again!!!!

"Duke Carey" wrote:

Use the Tools menu - go to Add-ins... and check Analysis Toolpak


"Jennifer Carver" wrote:

I am trying to use the formula =NETWORKDAYS so that I can calculate the
dirrence between dates and the computer will knwo which holidays to take out.
However, I am using Office 2003 and it doesn't have that formula in it. How
can I add that into my office program?



All times are GMT +1. The time now is 04:20 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com