Rounding Age Calculation

[Grandma8]

I am currently using the formula below to calculate age.
=DATEDIF(C3,K3,"Y")&" Years, "&DATEDIF(C3,K3,"YM")&" Months"
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
Now I'd like to have the calculation appear in two different formats.

<o></o>
A. Rounded to the nearest whole number (rounded down or up depending on the number of months)


B. Displayed in decimal format


Your help is much appreciated.

 

[VoG]

Try

A

=ROUNDUP(DATEDIF(C3,K3,"Y")&"."&DATEDIF(C3,K3,"YM")+0,0)

B

=DATEDIF(C3,K3,"Y")+DATEDIF(C3,K3,"YM")/12

 

[Andrew Poulsom]

To round up or down:

=ROUND(DATEDIF(C3,K3,"Y")+(DATEDIF(C3,K3,"YM")/12),0)

 

[Grandma8]

THANK YOU!

The formulas worked and it helps tremendously.