|
| 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
December 12th, 2005, 04:58 PM
posted to microsoft.public.excel.newusers
|
|||
|
|||
how to calculate an age from 10/8/1943
i have members birth dates in Exel an whant to display them diffrently
at present they are like this 10/8/1943, 1/3/1943. would like them to look like 62yrs 15days 
|
|
#2
December 12th, 2005, 05:09 PM
posted to microsoft.public.excel.newusers
|
|||
|
|||
|
how to calculate an age from 10/8/1943
http://www.cpearson.com/excel/datedif.htm
-- Regards, Peo Sjoblom "doctor who golf" doctor who wrote in message ... i have members birth dates in Exel an whant to display them diffrently at present they are like this 10/8/1943, 1/3/1943. would like them to look like 62yrs 15days
|
|
#3
December 12th, 2005, 05:12 PM
posted to microsoft.public.excel.newusers
|
|||
|
|||
|
how to calculate an age from 10/8/1943
Try something like this:
Where A1 contains the birthdate... B1: =DATEDIF(A1,TODAY(),"y")& "Yrs "&DATEDIF(A1,TODAY(),"yd")&" Days" For documentation on the DATEDIF function see Chip Pearson's site: http://www.cpearson.com/excel/datedif.htm Does that help? *********** Regards, Ron "doctor who golf" wrote: i have members birth dates in Exel an whant to display them diffrently at present they are like this 10/8/1943, 1/3/1943. would like them to look like 62yrs 15days
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Spreadsheet Won't Calculate | Scott | General Discussion | 0 | September 29th, 2005 05:37 PM |
| Total hours from Table into Report | HeatherLou1974 | General Discussion | 3 | March 7th, 2005 08:04 PM |
| How to calculate time difference? | barton | General Discussion | 4 | July 13th, 2004 05:49 AM |
| How to calculate time difference? | barton | General Discussion | 0 | July 12th, 2004 06:31 AM |
| Visual Basic....Calculate Button | Don Guillett | Worksheet Functions | 3 | April 2nd, 2004 05:24 PM |
Linear Mode
