EDate function + #NAME? error

[Guest]

Hi all,

I have a user with Excel 2000 experiencing a problem with her EDATE
function. Presently, she has her formula set to EDATE(+D12(J12*12)). Her
cells are formated with a custom date format. She does have the add-in
installed. She only seems to get the #NAME? error at the beginning of a new
year. She used to have her calculations on automatic, but for now they are on
manual. Any ideas on how to fix this?

Thanks!

 

[Gord Dibben]

Lina

If you had a look at EDATE in Excel help you would see that the Analysis Toolpak
add-in must be loaded through Tools>Add-ins.


Gord Dibben MS Excel MVP

 

[T. Valko]

EDATE(+D12(J12*12))

Your formula returns a #REF! error!

Did you mean:

=EDATE(D12,J12*12)

Biff

 

[Guest]

Gord,

With all due respect To an MS Excel MVP, I mentioned that already! "She does
have the add-in installed".

Lina

 

[Guest]

The error returned is #NAME? in the cell. And no, I copied the formula
exactly as the user has it in her ss.

Lina

 

[Gord Dibben]

Lina

Upon re-read of your original post I now see you did mention that.

Too much hurry or too little eyesight.

Apologies.


Gord

 

[Gord Dibben]

Try turning Calculation to Automatic maybe?


Gord

 

[Guest]

Gord,

She used to have them on automatic, but to temp fix her problem, I put her

 

[Ron Rosenfeld]

Hi all,

I have a user with Excel 2000 experiencing a problem with her EDATE
function. Presently, she has her formula set to EDATE(+D12(J12*12)). Her
cells are formated with a custom date format. She does have the add-in
installed. She only seems to get the #NAME? error at the beginning of a new
year. She used to have her calculations on automatic, but for now they are on
manual. Any ideas on how to fix this?

Thanks!

The first problem is that the formula is not in a valid syntax. Assuming D12
is a cell reference, I don't believe a cell reference can be followed by an
"(". +D12, or D12, are not valid NAME's.

So I think the first step would be to correct the syntax.


--ron

 

[Guest]

Yipe...this Excel stuff is beyond me! How come it works fine for every other
month except Feb.?

 

[Ron Rosenfeld]

Yipe...this Excel stuff is beyond me! How come it works fine for every other
month except Feb.?

As you have copied the formula here, it is not clear to me why it works at all!

Did you actually do a COPY/PASTE from her worksheet to your newsgroup message?
If you did, then I don't know how it works at all. If you did not, then please
correct the transcription error.
--ron