| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Age calculation
Hi all, I am trying to get a formula that will calculate someones age from their Date of birth, is this possible. Cheers -- Clash ------------------------------------------------------------------------ Clash's Profile: http://www.excelforum.com/member.php...o&userid=18951 View this thread: http://www.excelforum.com/showthread...hreadid=523477 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Age calculation
IF DOB is in A1, enter following formula in B2:
=YEAR(TODAY()-A1)-1900 and format it standard or number HTH -- AP "Clash" a écrit dans le message de ... Hi all, I am trying to get a formula that will calculate someones age from their Date of birth, is this possible. Cheers -- Clash ------------------------------------------------------------------------ Clash's Profile: http://www.excelforum.com/member.php...o&userid=18951 View this thread: http://www.excelforum.com/showthread...hreadid=523477 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Age calculation
Clash wrote
I am trying to get a formula that will calculate someones age from their Date of birth, is this possible. The most frequently suggested way is: DATEDIF(A1, TODAY(), "y") -- David |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Age calculation
Hello, I can get the Ardus Petus to work very well, but I can't seem to get the David formula ...DATEDIF(A1, TODAY(), "y")... to work. It looks like there may be a space between the ..first comma and today... and also a space between the ...second comma and the first quotation mark... Irregardless, I can't get it to work with or without a space. I have tried formating my formula cell to TEXT, then to NUMBER, and then to GENERAL. I can't get it to go. I also have put an equal sign at the first and that didn't help. Could the formula be incorrect or am I doing something wrong? -- lsmft ------------------------------------------------------------------------ lsmft's Profile: http://www.excelforum.com/member.php...o&userid=30678 View this thread: http://www.excelforum.com/showthread...hreadid=523477 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Age calculation
What specifically do you mean by "can't get it to work"? Do you
receive an error value in the cell? An unexpected result? Please be specific. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "lsmft" wrote in message ... Hello, I can get the Ardus Petus to work very well, but I can't seem to get the David formula ...DATEDIF(A1, TODAY(), "y")... to work. It looks like there may be a space between the ..first comma and today... and also a space between the ...second comma and the first quotation mark... Irregardless, I can't get it to work with or without a space. I have tried formating my formula cell to TEXT, then to NUMBER, and then to GENERAL. I can't get it to go. I also have put an equal sign at the first and that didn't help. Could the formula be incorrect or am I doing something wrong? -- lsmft ------------------------------------------------------------------------ lsmft's Profile: http://www.excelforum.com/member.php...o&userid=30678 View this thread: http://www.excelforum.com/showthread...hreadid=523477 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Age calculation
Found my error, it's working fine now. Thanks much and have a wonderful day -- lsmft ------------------------------------------------------------------------ lsmft's Profile: http://www.excelforum.com/member.php...o&userid=30678 View this thread: http://www.excelforum.com/showthread...hreadid=523477 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| MOREFUNC.XLL - RECALL() to trigger once only calculation? | Excel Discussion (Misc queries) | |||
| Calculation Setting in Excel | Excel Discussion (Misc queries) | |||
| How do I use a rounded calculation result in another calculation? | Excel Worksheet Functions | |||
| How do I use a rounded calculation result in another calculation? | Excel Worksheet Functions | |||
| time-clock calculation | Excel Worksheet Functions | |||
Linear Mode
