ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   NETWORKDAYS formula (https://www.excelbanter.com/excel-worksheet-functions/196961-networkdays-formula.html)

Susan

NETWORKDAYS formula
 
I have been using a networkdays formula in my database eversince I started
it, but now when I try to either copy or create an new networkdays formula in
the worksheet I get a #NAME! error saying it doesn't recognize text. I have
also noticed that if I search for the networkday formula it doesn't appear.
Anyone know why? Did I miss an update?

Thanks, Susan

David Biddulph[_2_]

NETWORKDAYS formula
 
Check the Excel help for the NETWORKDAYS formula. Occasionally the Analysis
ToolPak Add-In can become disconnected. Disable and Re-enable it. Sometimes
it might need an Excel restart or even a machine reboot between the Add-In
being disabled and enabled again.
--
David Biddulph

"Susan" wrote in message
...
I have been using a networkdays formula in my database eversince I started
it, but now when I try to either copy or create an new networkdays formula
in
the worksheet I get a #NAME! error saying it doesn't recognize text. I
have
also noticed that if I search for the networkday formula it doesn't
appear.
Anyone know why? Did I miss an update?

Thanks, Susan




Susan

NETWORKDAYS formula
 
THANKS! THAT WORKED! I'm so glad I found this board!

"David Biddulph" wrote:

Check the Excel help for the NETWORKDAYS formula. Occasionally the Analysis
ToolPak Add-In can become disconnected. Disable and Re-enable it. Sometimes
it might need an Excel restart or even a machine reboot between the Add-In
being disabled and enabled again.
--
David Biddulph

"Susan" wrote in message
...
I have been using a networkdays formula in my database eversince I started
it, but now when I try to either copy or create an new networkdays formula
in
the worksheet I get a #NAME! error saying it doesn't recognize text. I
have
also noticed that if I search for the networkday formula it doesn't
appear.
Anyone know why? Did I miss an update?

Thanks, Susan





David Biddulph[_2_]

NETWORKDAYS formula
 
Glad it helped.
--
David Biddulph

"Susan" wrote in message
...
THANKS! THAT WORKED! I'm so glad I found this board!

"David Biddulph" wrote:

Check the Excel help for the NETWORKDAYS formula. Occasionally the
Analysis
ToolPak Add-In can become disconnected. Disable and Re-enable it.
Sometimes
it might need an Excel restart or even a machine reboot between the
Add-In
being disabled and enabled again.
--
David Biddulph

"Susan" wrote in message
...
I have been using a networkdays formula in my database eversince I
started
it, but now when I try to either copy or create an new networkdays
formula
in
the worksheet I get a #NAME! error saying it doesn't recognize text. I
have
also noticed that if I search for the networkday formula it doesn't
appear.
Anyone know why? Did I miss an update?

Thanks, Susan








All times are GMT +1. The time now is 02:47 PM.

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