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-com
ffice
ffice" /><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.
=DATEDIF(C3,K3,"Y")&" Years, "&DATEDIF(C3,K3,"YM")&" Months"
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com




Now I'd like to have the calculation appear in two different formats.
<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.