About Us

richard flavell

I also run Excel 2007 under Vista. I also occasionally get exactly the same error, returning #N/A, when a valid function is reopened.
Have you found any solution, as I have not??

EggHeadCafe - .NET Developer Portal of Choice
http://www.eggheadcafe.com/default.aspx?ref=ng

T. Valko

Don't use EDATE.

See this thread in Google Groups for alternatives:

http://tinyurl.com/79hsqp

--
Biff
Microsoft Excel MVP

<richard flavell wrote in message
...
I also run Excel 2007 under Vista. I also occasionally get exactly the same
error, returning #N/A, when a valid function is reopened.
Have you found any solution, as I have not??

EggHeadCafe - .NET Developer Portal of Choice
http://www.eggheadcafe.com/default.aspx?ref=ng

Shane Devenshire[_2_]

Hi,

Keep your threads together. What was the original question?

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire

"richard flavell" wrote:

I also run Excel 2007 under Vista. I also occasionally get exactly the same error, returning #N/A, when a valid function is reopened.
Have you found any solution, as I have not??

EggHeadCafe - .NET Developer Portal of Choice
http://www.eggheadcafe.com/default.aspx?ref=ng

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
EDATE returns #NA Error when Excel opened again	SalD	Excel Worksheet Functions	6	February 21st 08 11:46 AM
EDATE returns #VALUE	IanC	Excel Worksheet Functions	4	May 21st 07 02:58 PM
EDate Unrecognized When Spreadsheet Opened Again	DallasLDY	Excel Worksheet Functions	9	January 5th 07 06:29 PM
#NAME? error using EDATE	Zimbob79	Excel Discussion (Misc queries)	2	March 26th 05 03:02 AM
The Help on the Excel Edate worksheet function contains an error:.	Guido	Excel Worksheet Functions	1	January 20th 05 01:42 PM

Menu

About Us