Fraction and age calculation

[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

 

[Norman Harker]

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.

 

[David McRitchie]

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

 

[Ragdyer]

<<"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 !
---------------------------------------------------------------------------

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
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

 

[David McRitchie]

Anybody who spends 15 hours a day in the newsgroups seems
Normal to me.

 

[Norman Harker]

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.

 

[Norman Harker]

Hi RD!

Sorry! Got my target wrong.

--
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">>
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 !
-------------------------------------------------------------------- -------

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
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page:

http://www.mvps.org/dmcritchie/excel/search.htm

 

[Ragdyer]

You just proved it AGAIN!<vvvvbg><darfc>