| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I put in a formula in Exel to calculate a persons age?
I have a formula in for someones age but it shows me their age that they will
be this year. How do I get it so it shows the correct age and then changes on their birthday. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I put in a formula in Exel to calculate a persons age?
See this. Scroll down near the bottom of this page:
http://www.cpearson.com/Excel/datedif.aspx -- Biff Microsoft Excel MVP "boofire19" wrote in message ... I have a formula in for someones age but it shows me their age that they will be this year. How do I get it so it shows the correct age and then changes on their birthday. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I put in a formula in Exel to calculate a persons age?
=DATEDIF(A1,TODAY(),"y") & " years old"
Assumes birthdate in A1 If you want a more detailed message............ =DATEDIF(A1,TODAY(),"y") & " years," & DATEDIF(A1,TODAY(),"ym") & " months,"& DATEDIF(A1,TODAY(),"md") & " days old" Gord Dibben MS Excel MVP On Thu, 18 Feb 2010 13:31:01 -0800, boofire19 wrote: I have a formula in for someones age but it shows me their age that they will be this year. How do I get it so it shows the correct age and then changes on their birthday. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I put in a formula in Exel to calculate a persons age?
Hi,
There is a problem with the DATEDIF() with an md. In cell A13, type 31/7/2007 I.e. 31 July 2007. In cell B13, type 02/03/2009 I.e. 2 March 2009. The following formula in Excel 2007, yields -1 (minus 1) as the answer =DATEDIF($A13,$B13,"md") I work around it by using =B13-EDATE(A13,(C13*12)+D13) C13 has DATEDIF($A13,$B13,"y"); D13 has DATEDIF($A13,$B13,"ym") Hope this helps. -- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "Gord Dibben" <gorddibbATshawDOTca wrote in message ... =DATEDIF(A1,TODAY(),"y") & " years old" Assumes birthdate in A1 If you want a more detailed message............ =DATEDIF(A1,TODAY(),"y") & " years," & DATEDIF(A1,TODAY(),"ym") & " months,"& DATEDIF(A1,TODAY(),"md") & " days old" Gord Dibben MS Excel MVP On Thu, 18 Feb 2010 13:31:01 -0800, boofire19 wrote: I have a formula in for someones age but it shows me their age that they will be this year. How do I get it so it shows the correct age and then changes on their birthday. |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I put in a formula in Exel to calculate a persons age?
=CONCATENATE("This person is ",(DATEDIF(A1,TODAY(),"y") & " years, " &
DATEDIF(A1,TODAY(),"ym") & "months, "& DATEDIF(A1,TODAY(),"md") & " days old")) It is yours with the addition of "This person is..." as a prefix. On Thu, 18 Feb 2010 14:02:37 -0800, Gord Dibben <gorddibbATshawDOTca wrote: =DATEDIF(A1,TODAY(),"y") & " years old" Assumes birthdate in A1 If you want a more detailed message............ =DATEDIF(A1,TODAY(),"y") & " years," & DATEDIF(A1,TODAY(),"ym") & " months,"& DATEDIF(A1,TODAY(),"md") & " days old" Gord Dibben MS Excel MVP On Thu, 18 Feb 2010 13:31:01 -0800, boofire19 wrote: I have a formula in for someones age but it shows me their age that they will be this year. How do I get it so it shows the correct age and then changes on their birthday. |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I put in a formula in Exel to calculate a persons age?
Do they have any intention of fixing it?
On Sat, 20 Feb 2010 11:46:09 +0530, "Ashish Mathur" wrote: Hi, There is a problem with the DATEDIF() with an md. In cell A13, type 31/7/2007 I.e. 31 July 2007. In cell B13, type 02/03/2009 I.e. 2 March 2009. The following formula in Excel 2007, yields -1 (minus 1) as the answer =DATEDIF($A13,$B13,"md") I work around it by using =B13-EDATE(A13,(C13*12)+D13) C13 has DATEDIF($A13,$B13,"y"); D13 has DATEDIF($A13,$B13,"ym") Hope this helps. |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I put in a formula in Exel to calculate a persons age?
Why can I not find "DATEDIF" in the function reference in the help file?
On Sun, 21 Feb 2010 13:38:55 -0800, CellShocked <cellshocked@thecellvalueattheendofthespreadsheet. org wrote: Do they have any intention of fixing it? On Sat, 20 Feb 2010 11:46:09 +0530, "Ashish Mathur" wrote: Hi, There is a problem with the DATEDIF() with an md. In cell A13, type 31/7/2007 I.e. 31 July 2007. In cell B13, type 02/03/2009 I.e. 2 March 2009. The following formula in Excel 2007, yields -1 (minus 1) as the answer =DATEDIF($A13,$B13,"md") I work around it by using =B13-EDATE(A13,(C13*12)+D13) C13 has DATEDIF($A13,$B13,"y"); D13 has DATEDIF($A13,$B13,"ym") Hope this helps. |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I put in a formula in Exel to calculate a persons age?
Why can I not find "DATEDIF" in the function
reference in the help file? Read the first paragraph on this page: http://www.cpearson.com/Excel/datedif.aspx -- Biff Microsoft Excel MVP "Lil Red Riding In The Hood" <lilredridinginthehood@grandmashouseattheendoftheu niverse.org wrote in message ... Why can I not find "DATEDIF" in the function reference in the help file? On Sun, 21 Feb 2010 13:38:55 -0800, CellShocked <cellshocked@thecellvalueattheendofthespreadsheet. org wrote: Do they have any intention of fixing it? On Sat, 20 Feb 2010 11:46:09 +0530, "Ashish Mathur" wrote: Hi, There is a problem with the DATEDIF() with an md. In cell A13, type 31/7/2007 I.e. 31 July 2007. In cell B13, type 02/03/2009 I.e. 2 March 2009. The following formula in Excel 2007, yields -1 (minus 1) as the answer =DATEDIF($A13,$B13,"md") I work around it by using =B13-EDATE(A13,(C13*12)+D13) C13 has DATEDIF($A13,$B13,"y"); D13 has DATEDIF($A13,$B13,"ym") Hope this helps. |
|
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I put in a formula in Exel to calculate a persons age?
No
-- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "CellShocked" <cellshocked@thecellvalueattheendofthespreadsheet. org wrote in message ... Do they have any intention of fixing it? On Sat, 20 Feb 2010 11:46:09 +0530, "Ashish Mathur" wrote: Hi, There is a problem with the DATEDIF() with an md. In cell A13, type 31/7/2007 I.e. 31 July 2007. In cell B13, type 02/03/2009 I.e. 2 March 2009. The following formula in Excel 2007, yields -1 (minus 1) as the answer =DATEDIF($A13,$B13,"md") I work around it by using =B13-EDATE(A13,(C13*12)+D13) C13 has DATEDIF($A13,$B13,"y"); D13 has DATEDIF($A13,$B13,"ym") Hope this helps. |
|
#10
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I put in a formula in Exel to calculate a persons age?
On Sun, 21 Feb 2010 21:30:46 -0500, "T. Valko"
wrote: Why can I not find "DATEDIF" in the function reference in the help file? Read the first paragraph on this page: http://www.cpearson.com/Excel/datedif.aspx Thank you. That is perfect. |
|
#11
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I put in a formula in Exel to calculate a persons age?
On Mon, 22 Feb 2010 08:34:26 +0530, "Ashish Mathur"
wrote: No Well, that was SUCK-sinct! |
|
#12
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I put in a formula in Exel to calculate a persons age?
If you have the Analysis Toolpack add-in (Tools menu, choose Add-ins and
check Analysis toolpack) you can also use =INT(DAYS360(birthdate,TODAY())/360) "boofire19" wrote: I have a formula in for someones age but it shows me their age that they will be this year. How do I get it so it shows the correct age and then changes on their birthday. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| caculate a persons age | Excel Worksheet Functions | |||
| what formula do i need to calculate a persons age | Excel Discussion (Misc queries) | |||
| Exel formula | Excel Discussion (Misc queries) | |||
| exel conditional formula,calculate a bilateral tolerance(.2/-.2)? | Excel Discussion (Misc queries) | |||
| Does anyone know how to calculate Yield to Maturity using Exel? | Excel Worksheet Functions | |||
Linear Mode
