|
| 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 | Search this Thread | Display Modes |
|
#1
March 17th 10, 03: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 
|
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| How to quickly see someone's availability w/o scheduling a meeting | Lisa | Outlook - Calandaring | 2 | October 1st 09 01:41 PM |
| How can I: Automatically Add someone's address when he sends me em | Alexandros | Outlook - Using Contacts | 7 | April 8th 09 06:53 PM |
| Can our receptionist let us know when someone's arrived? | Widmerpool | Outlook - Calandaring | 5 | August 6th 08 06:12 PM |
| Receive notification when someone's calendar is updated | [email protected] | Outlook - Calandaring | 1 | March 2nd 08 10:52 PM |
| Managing someone's distribution lists | Dave[_3_] | Outlook - Using Contacts | 0 | September 18th 07 04:43 PM |
Threaded Mode