YearFrac

[Doug Mc]

Here's my formula: =YEARFRAC(B3,$D$2)
I get an error (#NAME$)

What am I doing wrong?

Thanks,
Doug

 

[JE McGimpsey]

From XL Help ("YEARFRAC"):

If this function is not available, and returns the #NAME? error, install
and load the Analysis ToolPak add-in.

 

[Lady Layla]

You need Start date, End Date and Basis according to Help

But you also need to enter the dates as =date(yyyy,mm,dd) because you may have
problems if they are entered as text




:
: Here's my formula: =YEARFRAC(B3,$D$2)
: I get an error (#NAME$)
:
: What am I doing wrong?
:
: Thanks,
: Doug
:
:

 

[Doug Mc]

I'm using XL97. Does that make a difference?
And how would I "install and load the Analysis Toolpak add-in?"

Thanks,
Doug

 

[JE McGimpsey]

I don't have XL97 loaded, but I'd have thought that Help would have had
an entry about the Analysis Toolpak add-in.

Choose Tools/Add-ins... Check the ATP checkbox, then click OK to load
the ATP.

 

[Doug Mc]

I did "Analysis ToolPak" and "Analysis ToolPak - VBA" and clicked OK. It
didn't give me a message if it loaded anything or not. I did it twice.
Nothing changed.

Do I need to do something else??
Thanks again,
Doug

 

[Gord Dibben]

Doug

You won't get a message when ATP(don't need ATP for VBA) loads after checking
it in Tools>Add-ins.

Tools menu. Do you have "Data Analysis" entry at bottom?

If so, this means ATP is loaded.

Try hitting F9 to force a re-calculation of the cells.

Does #NAME go away?

Gord Dibben Excel MVP

 

[Doug Mc]

Yes, "Data Analysis" is there.
I hit f9 and got a date entered. Shouldn't I be getting a number of years,
etc.??
My first date is "07/26/32"; the second one is "11/17/04" and I got a result
of "03/12/00" (ignore the quotes; the cells are defined as dates.)

At least I now have something!
NOW, what am I doing wrong?

Thanks Gord,
Doug

 

[Gord Dibben]

Doug

With my setup(US) a date is entered d/m/y

m/d/y is text

26/07/32 returns July 26, 2032 in A1

17/11/04 returns November 17, 2004 in B1

=YEARFRAC(A1,B1,2) in C1 returns 28.091667 when formatted as General or
Number.

Gord Dibben Excel MVP

 

[Max]

Try changing the format of the formula cell
(the one with the : =YEARFRAC(B3,$D$2))
to either "General" or "Number"

[Click Format > Cells > General (or Number)]

 

[Doug Mc]

Thanks Max,
That worked out just fine.

Doug

Try changing the format of the formula cell
(the one with the : =YEARFRAC(B3,$D$2))
to either "General" or "Number"

[Click Format > Cells > General (or Number)]

--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <at>yahoo<dot>com
----

Yes, "Data Analysis" is there.
I hit f9 and got a date entered. Shouldn't I be getting a number of years,
etc.??
My first date is "07/26/32"; the second one is "11/17/04" and I got a result
of "03/12/00" (ignore the quotes; the cells are defined as dates.)

At least I now have something!
NOW, what am I doing wrong?

Thanks Gord,
Doug

 

[Max]

You're welcome !