Formatting Cell

[traff1982]

Hi

I'm working on a spreadsheet that requires one of the cells to show the age of people. I'm ok with finding the age but i need to show it in the form of fraction with a denominator of 12. e.g. someone who is 56 and 6 months would be shown as "56 6/12" rather than "56 1/2". I can format the cell so it shows fractions but they are not with a denominator of 12. Any tips on how to do this would be appreciated.

Cheers

 

[Lewiy]

Try this number format:
# ??/12

 

[cata2200]

Hi

I'm a beginner, but I can try to work like this:

Let say
A1: Today Date
A2: Birth Date
A3: =A2-A1 ' Format the cell as a number, not data
A4: =int(A3/365) ' No. of years.
A5: =int(A4/4) ' no 366 days in a year
A6: =INT((A3-B4*365+C4)/30) ' for number of months
A7: =concatenate(a4, " ", A6,"/12")

Of course, you can write the formula in oly one row.

Regards
Catalin