Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
NETWORKDAYS #NAME?
I have used this formula with great success in previous sheets in the same
workbook but now I keep getting the above error. I have all the add in's as pre previous answers and replies but still no joy. I tried formatting the cell but again no joy. Can anyone suggest a solution please? Thanks Angie |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
NETWORKDAYS #NAME?
On Mon, 7 Apr 2008 07:08:01 -0700, Angiewelly
wrote: I have used this formula with great success in previous sheets in the same workbook but now I keep getting the above error. I have all the add in's as pre previous answers and replies but still no joy. I tried formatting the cell but again no joy. Can anyone suggest a solution please? Thanks Angie Perhaps the #NAME! error refers to your data (function arguments) rather than the function itself. What version of Excel? --ron |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
NETWORKDAYS #NAME?
This link might provide some help/ ideas:
http://help.lockergnome.com/office/N...ict692119.html "Ron Rosenfeld" wrote: On Mon, 7 Apr 2008 07:08:01 -0700, Angiewelly wrote: I have used this formula with great success in previous sheets in the same workbook but now I keep getting the above error. I have all the add in's as pre previous answers and replies but still no joy. I tried formatting the cell but again no joy. Can anyone suggest a solution please? Thanks Angie Perhaps the #NAME! error refers to your data (function arguments) rather than the function itself. What version of Excel? --ron |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
NETWORKDAYS #NAME?
Excel 2003
"Ron Rosenfeld" wrote: On Mon, 7 Apr 2008 07:08:01 -0700, Angiewelly wrote: I have used this formula with great success in previous sheets in the same workbook but now I keep getting the above error. I have all the add in's as pre previous answers and replies but still no joy. I tried formatting the cell but again no joy. Can anyone suggest a solution please? Thanks Angie Perhaps the #NAME! error refers to your data (function arguments) rather than the function itself. What version of Excel? --ron |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
NETWORKDAYS #NAME?
On Mon, 7 Apr 2008 07:57:03 -0700, Angiewelly
wrote: Excel 2003 "Ron Rosenfeld" wrote: On Mon, 7 Apr 2008 07:08:01 -0700, Angiewelly wrote: I have used this formula with great success in previous sheets in the same workbook but now I keep getting the above error. I have all the add in's as pre previous answers and replies but still no joy. I tried formatting the cell but again no joy. Can anyone suggest a solution please? Thanks Angie Perhaps the #NAME! error refers to your data (function arguments) rather than the function itself. What version of Excel? --ron Copy and paste the formula below into some cell. Do you still get a #NAME! error? =NETWORKDAYS(DATE(2008,1,1),DATE(2008,1,31)) --ron |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
NETWORKDAYS | Excel Worksheet Functions | |||
NETWORKDAYS | Excel Discussion (Misc queries) | |||
Networkdays | Excel Discussion (Misc queries) | |||
#NAME when using NETWORKDAYS | Excel Discussion (Misc queries) | |||
networkdays | Excel Worksheet Functions |