Year/Month calculation

[The Animal]

Hi
I am using below to use todays date and the entered date in cell B7 to calculate the years and months elapsed between the 2 but keep getting a #num error.
Any help would be great.

=DATEDIF(TODAY(),B7,"y")&" years, "&DATEDIF(TODAY(),B7,"ym")&" months"

Thanks Stephen

 

[barry houdini]

You need to reverse the dates, i.e.

=DATEDIF(B7,TODAY(),"y")&" years, "&DATEDIF(B7,TODAY(),"ym")&" months"

 

[The Animal]

O fantastic that was easy thanks so much.
Another issue is that I have used your above and copied down and works perfect except if "B" cell is blank then give me 117 years and 9 months instead of a blank cell which is what I would like?

 

[barry houdini]

You can use an IF function to return a blank if B7 is blank, e.g.

=IF(B7="","",DATEDIF(B7,TODAY(),"y")&" years, "&DATEDIF(B7,TODAY(),"ym")&" months")

 

[The Animal]

Thanks so much