# Formatting Cell

#### traff1982

##### Board Regular
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

### Excel Facts

What is =ROMAN(40) in Excel?
The Roman numeral for 40 is XL. Bill "MrExcel" Jelen's 40th book was called MrExcel XL.

#### Lewiy

##### Well-known Member
Try this number format:
# ??/12

#### cata2200

##### Board Regular
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

Replies
20
Views
568
Replies
2
Views
199
Replies
7
Views
353
Replies
2
Views
257
Replies
3
Views
283

1,191,684
Messages
5,987,998
Members
440,125
Latest member
vincentchu2369

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back