Datedif function in excel

[foucauld]

Hi everyone,

New to the forum and kind of to excel.

I have searched the net for some kind of answer but cannot find one.. that I understand anyway.

i have worked out the difference between two dates and used datedif to show answer as #years, # months, #days.... (I copied the formula off the net somewhere) =DATEDIF(B1,A1,"y")&" years, "&DATEDIF(B1,A1,"ym")&" months, "&DATEDIF(B1,A1,"md")&" days"

but how can I just show years and days? I will be feeding the result into an oracle based system which only has fields for year and days.

Thanks for any help.

[daddylonglegs]

You can amend that formula to this for years and days

=DATEDIF(B1,A1,"y")&" years "&DATEDIF(B1,A1,"yd")&" days"

[foucauld]

OH! That simple!! lol

Many Thanks.