Function "DATEDIF" does not exist in my excel 2010 version

[ROLAND.]

Do I need to activate or download an add-in to make this function work ?
Thx.
Roland

 

[sgmansell]

Sorry, I tried this formula, =DATEDIF(6/5/2013,3/28/1951,y) and received this error: #NAME?

Do I need to activate something in excel 2010?

 

[FormR]

Try:

=DATEDIF("3/28/1951","6/5/2013","y")

EDIT: Welcome to the forum!

 

[sgmansell]

Try:

=DATEDIF("3/28/1951","6/5/2013","y")

EDIT: Welcome to the forum!

Thanks, this worked. I also put the dates and y in their own cells and that worked also.

I'm looking forward to gaining more knowledge regarding EXCEL here.

 

[leebre]

I'm not able to get this function to work correctly at all. here is what i have been trying:
=dateif(B20,B21,"y") no luck returns the #NAME error.
B20 = today()
B21 = 6/25/2022

I also tried entering the actual dates in to the function and still returned nothing.
=dateif("8/26/2014","6/25/2022","y")

 

[Rick Rothstein]

I'm not able to get this function to work correctly at all. here is what i have been trying:
=dateif(B20,B21,"y") no luck returns the #NAME error.
B20 = today()
B21 = 6/25/2022

I also tried entering the actual dates in to the function and still returned nothing.
=dateif("8/26/2014","6/25/2022","y")

The function name is DATEDIF

 

[leebre]

I totally missed that! LOL works perfect now! thanks for your reply.