| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Help need with formula
I need to work out how many years and months someone been alive. Can anyone help? -- smith.james0 ------------------------------------------------------------------------ smith.james0's Profile: http://www.excelforum.com/member.php...o&userid=16230 View this thread: http://www.excelforum.com/showthread...hreadid=374933 |
|
#2
|
|||
|
|||
|
This is one option: A1: birthdate B1: =DATEDIF(A1,TODAY(),"Y")&" years & "&MOD(DATEDIF(A1,TODAY(),"M"),12)&" months" Ola Sandström -- olasa ------------------------------------------------------------------------ olasa's Profile: http://www.excelforum.com/member.php...o&userid=17760 View this thread: http://www.excelforum.com/showthread...hreadid=374933 |
|
#3
|
|||
|
|||
|
Also... =DATEDIF(A1,TODAY(),"Y")&" Years, "&DATEDIF(A1,TODAY(),"YM")&" Months" Hope this helps! -- Domenic ------------------------------------------------------------------------ Domenic's Profile: http://www.excelforum.com/member.php...o&userid=10785 View this thread: http://www.excelforum.com/showthread...hreadid=374933 |
|
#4
|
|||
|
|||
|
Much better... -- olasa ------------------------------------------------------------------------ olasa's Profile: http://www.excelforum.com/member.php...o&userid=17760 View this thread: http://www.excelforum.com/showthread...hreadid=374933 |
|
#5
|
|||
|
|||
|
Try the Datedif function.
It's undocumented except in XL2k. BUT, you can find it explained at Chip Pearson's web site at: http://www.cpearson.com/excel/datedif.htm -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "smith.james0" wrote in message news:smith.james0.1ptaab_1117400703.8379@excelforu m-nospam.com... I need to work out how many years and months someone been alive. Can anyone help? -- smith.james0 ------------------------------------------------------------------------ smith.james0's Profile: http://www.excelforum.com/member.php...o&userid=16230 View this thread: http://www.excelforum.com/showthread...hreadid=374933 |
|
#6
|
|||
|
|||
|
Hi
Have a look at DATEDIF. Here is some info on how it works: http://www.cpearson.com/excel/datedif.htm Andy. "smith.james0" wrote in message news:smith.james0.1ptaab_1117400703.8379@excelforu m-nospam.com... I need to work out how many years and months someone been alive. Can anyone help? -- smith.james0 ------------------------------------------------------------------------ smith.james0's Profile: http://www.excelforum.com/member.php...o&userid=16230 View this thread: http://www.excelforum.com/showthread...hreadid=374933 |
|
#7
|
|||
|
|||
|
Thanks a lot that works great :) -- smith.james0 ------------------------------------------------------------------------ smith.james0's Profile: http://www.excelforum.com/member.php...o&userid=16230 View this thread: http://www.excelforum.com/showthread...hreadid=374933 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| referencing named formula using INDIRECT function | Excel Worksheet Functions | |||
| Simplify formula | Excel Worksheet Functions | |||
| put formula results into a different cell if it is empty | Excel Worksheet Functions | |||
| how do i write a formula and keep in in formula form, so it DOESN. | Excel Discussion (Misc queries) | |||
| Match / Vlookup within an Array formula | Excel Discussion (Misc queries) | |||
Linear Mode
