#1   Report Post  
Old April 7th 08, 03:08 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jun 2007
Posts: 10
Default 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   Report Post  
Old April 7th 08, 03:25 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 5,651
Default 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   Report Post  
Old April 7th 08, 03:33 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Nov 2006
Posts: 50
Default 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   Report Post  
Old April 7th 08, 03:57 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jun 2007
Posts: 10
Default 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   Report Post  
Old April 7th 08, 04:20 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 5,651
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
NETWORKDAYS Suzanne Excel Worksheet Functions 7 April 2nd 07 09:32 AM
NETWORKDAYS Suddes Excel Discussion (Misc queries) 7 March 22nd 07 04:04 PM
Networkdays Dave Excel Discussion (Misc queries) 3 January 13th 07 05:58 PM
#NAME when using NETWORKDAYS Amy Excel Discussion (Misc queries) 4 June 29th 06 10:17 PM
networkdays rsenn Excel Worksheet Functions 0 November 24th 05 01:42 AM


All times are GMT +1. The time now is 10:36 AM.

Powered by vBulletin® Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
Copyright 2004-2017 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017