Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Machead in a Microsoft World
 
Posts: n/a
Default why won't EDATE function work in Excel?

I can't seem to get this function to work. Even the example from the Office
website is returning a #NAME? error. Help?

  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
daddylonglegs
 
Posts: n/a
Default why won't EDATE function work in Excel?


EDATE function is part of Analysis ToolPak add-in, you get #NAME? error
if it isn't installed.

To install

Tools Addins tick Analysis ToolPak box


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=525074

  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Machead in a Microsoft World
 
Posts: n/a
Default why won't EDATE function work in Excel?

Thanks much daddylonglegs! It's all good now.

"daddylonglegs" wrote:


EDATE function is part of Analysis ToolPak add-in, you get #NAME? error
if it isn't installed.

To install

Tools Addins tick Analysis ToolPak box


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=525074


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
Is there a way for excel to recognise that €0.00 = 0 for the purposes IF function ? CmTaz Excel Discussion (Misc queries) 4 March 6th 06 03:45 AM
Why sometimes excel returns error just because function parameters are linked? Paul134 Excel Worksheet Functions 2 February 28th 06 05:15 PM
@ and "function not valid" error (Excel 2003) Acert93 New Users to Excel 1 September 2nd 05 07:17 AM
Does excel have a 'cubed root' function? How can it work it out? Di in Oz Excel Worksheet Functions 1 April 30th 05 12:37 AM
The Help on the Excel Edate worksheet function contains an error:. Guido Excel Worksheet Functions 1 January 20th 05 01:42 PM


All times are GMT +1. The time now is 01:19 AM.

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

About Us

"It's about Microsoft Excel"