Calculate someone's age

  • Thread starter LATINCUTIEPIE00 via OfficeKB.com
  • Start date
L

LATINCUTIEPIE00 via OfficeKB.com

I have a list of birthdays 11/17/1975 on cell A1 and 11/17/2010 on cell B1...
on C1 I have this formula:

=INT(YEARFRAC(TODAY(),A,1,1)) which makes the age 34 (if i format the cell to
General or number)

...It tells me what age this person is but if I change the date on B1 to
11/17/2011 (for example), it wont change the age on C1 to 35...

What is the formula to do this change?

Thanks,
Trish
 
B

Brian Tillman [MVP-Outlook]

I have a list of birthdays 11/17/1975 on cell A1 and 11/17/2010 on cell B1...
on C1 I have this formula:

=INT(YEARFRAC(TODAY(),A,1,1)) which makes the age 34 (if i format the cell
to
General or number)

..It tells me what age this person is but if I change the date on B1 to
11/17/2011 (for example), it wont change the age on C1 to 35...

What is the formula to do this change?
Click to expand...

How is this an Outlook question?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to use/create code in MS Word to calculate age? 0
Calculating age from date of birth and ignoring if blank 3
Calculating age 1
Need a query to return a value if out of range 4
Conditional formula's in excel-calculating with dates / age andaffiliation date calculus 3
Find then highlight in yellow 6
Transpose 4 Columns data to Rows for Employee Time In and Time Out Schedule 0
HELP for calculating gestational age based on date 2

Top