|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
March 17th, 2010, 02:05 PM
posted to microsoft.public.outlook.contacts
|
|||
|
|||
Calculate someone's age
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 -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...tacts/201003/1 
|
|
#2
March 17th, 2010, 02:46 PM
posted to microsoft.public.outlook.contacts
|
|||
|
|||
|
Calculate someone's age
"LATINCUTIEPIE00 via OfficeKB.com" u53174@uwe wrote in message
news:a525520537d23@uwe... 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? How is this an Outlook question? -- Brian Tillman [MVP-Outlook]
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
