• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 537
  • Last Modified:

Edate #Name error

Hi Experts

I am having trouble with the following formula
In cell B2 I have Aug
In cell A2 I have =Edate(B2,-1)

To give me July in A2 but I am getting. #Name ? Error

I have formatted the cell to custom mmm

What's wrong here???
0
route217
Asked:
route217
  • 3
  • 3
1 Solution
 
Rob HensonIT & Database AssistantCommented:
Is the value of B2 literally just the word Aug or is it an actual date formatted to "mmm"?

It needs to be an actual date.

Thanks
Rob H
0
 
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
Hello,

The Name error means that an unknown function is used.
what version of Excel? Edate is only available when you activate the Analysis ToolPak in versions before 2007.

Does B2 have the TEXT "Aug" or is it a real date? If it is a real date, then the Name error points to the function not being known. If it is a text, then the Value error will be displayed, because Edate needs a real date to work with.

cheers, teylyn
0
 
route217Author Commented:
Hi rob

The date is in cell 01/08/2012 formatted to dd/mm/yyyy
0
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 
route217Author Commented:
Hi Teylyn

I am using 2003..at present. Also is there a function compat wit both 03 and 07..
0
 
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
And, as a general good practice rule for designing workbooks: Data and formulas should flow from top left to bottom right, because that way they will be aligned with the way Excel looks at the spreadsheet and will get calculated faster.

A formula ideally should only refer to cells above and to the left, not to cells below and to the right.

That's the golden rule. There are always exceptions, of course.
0
 
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
OK, in Excel 2003 click Tools > Add-ins and tick the check box next to "Analysis ToolPak"

Depending on your setup, you may need to provide the Office installation disk/location.

cheers, teylyn
0
 
route217Author Commented:
Thanks for the feedback experts works
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 3
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now