Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Creating an exact time display
Hello Somebody,,
I could use some help with this one. I'm trying to create a formula using MS Excel because several persons will be using this file, and they should have this software on their machines. OK, let's say that I wanted to determine the exact age of an individual that has died. I want everything figured in,,, like leap years and such. I would like to enter two dates; their birth date and their date of death. and I would like a date that formats something like one of the following: 49 "Years" & 72 "Days" or like this: 49 "Years", 3 "Months" & 17 "Days" Would appreciate any help along this line if I can get someone that's up for the challenge..... Thanks in advance for your help, Jeffrey Thomas |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Creating an exact time display
Hi Pref
See http://www.cpearson.com/excel/datedif.htm -- Regards Ron de Bruin http://www.rondebruin.nl "Pref" wrote in message ... Hello Somebody,, I could use some help with this one. I'm trying to create a formula using MS Excel because several persons will be using this file, and they should have this software on their machines. OK, let's say that I wanted to determine the exact age of an individual that has died. I want everything figured in,,, like leap years and such. I would like to enter two dates; their birth date and their date of death. and I would like a date that formats something like one of the following: 49 "Years" & 72 "Days" or like this: 49 "Years", 3 "Months" & 17 "Days" Would appreciate any help along this line if I can get someone that's up for the challenge..... Thanks in advance for your help, Jeffrey Thomas |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Creating an exact time display
=DATEDIF(A1,TODAY(),"y")&" years "&DATEDIF(A1,TODAY(),"ym")&" months
"&DATEDIF(A1,TODAY(),"md")&" days" -- HTH Bob Phillips (replace somewhere in email address with googlemail if mailing direct) "Pref" wrote in message ... Hello Somebody,, I could use some help with this one. I'm trying to create a formula using MS Excel because several persons will be using this file, and they should have this software on their machines. OK, let's say that I wanted to determine the exact age of an individual that has died. I want everything figured in,,, like leap years and such. I would like to enter two dates; their birth date and their date of death. and I would like a date that formats something like one of the following: 49 "Years" & 72 "Days" or like this: 49 "Years", 3 "Months" & 17 "Days" Would appreciate any help along this line if I can get someone that's up for the challenge..... Thanks in advance for your help, Jeffrey Thomas |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Creating an exact time display
I would like to thank both parties that answered my post... I recieved
exactly what I needed... Thanks again.. "Bob Phillips" wrote: =DATEDIF(A1,TODAY(),"y")&" years "&DATEDIF(A1,TODAY(),"ym")&" months "&DATEDIF(A1,TODAY(),"md")&" days" -- HTH Bob Phillips (replace somewhere in email address with googlemail if mailing direct) "Pref" wrote in message ... Hello Somebody,, I could use some help with this one. I'm trying to create a formula using MS Excel because several persons will be using this file, and they should have this software on their machines. OK, let's say that I wanted to determine the exact age of an individual that has died. I want everything figured in,,, like leap years and such. I would like to enter two dates; their birth date and their date of death. and I would like a date that formats something like one of the following: 49 "Years" & 72 "Days" or like this: 49 "Years", 3 "Months" & 17 "Days" Would appreciate any help along this line if I can get someone that's up for the challenge..... Thanks in advance for your help, Jeffrey Thomas |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Time display | Excel Discussion (Misc queries) | |||
Time Display Question Please | Excel Discussion (Misc queries) | |||
Time Display ? | Excel Worksheet Functions | |||
conditional formatting with time values | Excel Discussion (Misc queries) | |||
Dynamic Time Display | Excel Worksheet Functions |