years and months between two dates

[Sheepskin_Coat]

i have tried to do a datedif formula in excel 2007, all i get in the cell is #num error

What i am trying to do is i have a date i.e. 01/06/2001 in cell a1, and a date in cell b1 18/08/2010, what i want to do is get how many months and years between two dates, is there any way of doing this

Many Thanks

 

[Zakkaroo]

Assuming that Date #1 is in A1 and Date #2 is in A2

=DATEDIF(A1,A2,"Y")&" Years, "&DATEDIF(A1,A2,"YM")&" Months"

 

[Sheepskin_Coat]

when i try that i get a #num error, iam using excel 2007

 

[barry houdini]

The first date needs to be earlier than the second, otherwise you get #NUM! error, try reversing the order of the dates....

 

[Sheepskin_Coat]

yes i see that now thanks for all you help