missing datedif

[dhester2]

I have two computers running office 2010 both are the same version of excel and have all the latest updates, on one the datedif function works on the other i just get #name.

Any ideas?

[Colin Legg]

Welcome to the forum.

Can you give the exact formula where #NAME? is being returned?

[daddylonglegs]

Any ideas?

As a guess I would say you are probably missing the quotes from the 3rd argument, e.g. this will return #NAME?

=DATEDIF(A1,B1,m)

it should be

=DATEDIF(A1,B1,"m")

[Marcol]

DATEDIF() is a Microsoft unsupported function available in most versions of Excel.

It might be that it has been dropped from 2010, hence you will get #NAME? Just a thought I don't know for sure.

[dhester2]

the way I am using the function is =datedif(e4,e5,D). e4 is 17/2/12 and e5 is 30/3/12.

[dhester2]

I know datedif is unsupported and may have been dropped but why would it work on one computer and not the other?

[Colin Legg]

Okay, so the D at the end is the problem. It should be in quotes.

=DATEDIF(E4,E5,"D")

Or, you could just use this instead:

=E5-E4

and format the cell as a number.

[Marcol]

Different versions of Excel on these computers?

More likely it's as DLL said you don't have D in parenthisis i.e. "d"

[dhester2]

Colin Thanks for the help, when I changed the formula to =datedif(e5,e4,"D") it worked on both computers.

Still not sure why it worked without the "" on one computer and not the other.

Marcol
Same version of windows (windows 7 professional 32 bit with office 32 bit) on both computers.

[Colin Legg]

Hi,

The only way I can think that it would work without the quotes is if the workbook contained a defined name, D, which was defined as ="D".

Glad you got it fixed now.

[daddylonglegs]

Hey Colin!

How's married life treating you?