Fraction and age calculation

  • Thread starter Thread starter milesryl
  • Start date Start date
M

milesryl

Two questions:

1. I am trying to enter a fraction into a cell but it keeps reducing i
to the lowest common denominator. How do I get it to keep the exac
fraction I've entered?

2. How do I calculate how old a person is, displayed as a single an
whole number, given their date of birth and todays date. My date o
birth cell is J6 and the age cell is J7.

Thank
 
Hi milesryl!

Try to keep to one question per thread.

Fractions:

Use a custom format to avoid the fraction simplifying:

eg
# ??/12

Will display (eg) 5 6/12

Age:

Assuming you want years:

=DATEDIF(J6,TODAY(),"y")

For details of DATEDIF see:

Chip Pearson:
http://www.cpearson.com/excel/datedif.htm
--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Sorry didn't see Normal had already answered, but will still point out
that results from DATEDIF are subject to interpretation.

#1 if you aren't using the fraction numerically you can enter the
fraction as text by preceding it with a single quote.

#2 to show the age of a person see DATEDIF on Chip Pearson's site.
http://www.cpearson.com/excel/datedif.htm

Example on his site, but read the web page. DATEDIF calculates thise numbers
similar to the way you probably would, but differences may occur when dates
include a day of month greater than 28 in the dates you are finding the difference
between.
=DATEDIF(A1,NOW(),"y") & " years, " & DATEDIF(A1,NOW(),"ym") & " months, " & DATEDIF(A1,NOW(),"md") & " days"
his will return a string like 33 years, 9 months, 18 days
 
<<"Sorry didn't see Normal had already answered">>
Some folks don't consider him that!<bg>

(Sorry ... just couldn't resist)<g>
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
David McRitchie said:
Sorry didn't see Normal had already answered, but will still point out
that results from DATEDIF are subject to interpretation.

#1 if you aren't using the fraction numerically you can enter the
fraction as text by preceding it with a single quote.

#2 to show the age of a person see DATEDIF on Chip Pearson's site.
http://www.cpearson.com/excel/datedif.htm

Example on his site, but read the web page. DATEDIF calculates thise numbers
similar to the way you probably would, but differences may occur when dates
include a day of month greater than 28 in the dates you are finding the difference
between.
=DATEDIF(A1,NOW(),"y") & " years, " & DATEDIF(A1,NOW(),"ym") & " months, "
Click to expand...
& DATEDIF(A1,NOW(),"md") & " days"
 
Hi Gord!

A1:
Some folks don't consider him that!<bg>
A2:
=SUBSTITUTE(SUBSTITUTE(A1,"Some","Most"),"<bg>",":(")

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Back
Top