Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Please help, i need a fomula
hi
I was wondering if anyone had a solution? I have a formula cell with a date of birth and a cell with the date now, and i wanted to know whether i could work out a cell to work out a formula for excel to work out an age, and automatically change with the current date. Is this at all possable? please email me with your responce to . Thank you so much. |
#2
|
|||
|
|||
Age Formula?? Wrote: hi I was wondering if anyone had a solution? I have a formula cell with a date of birth and a cell with the date now, and i wanted to know whether i could work out a cell to work out a formula for excel to work out an age, and automatically change with the current date. Is this at all possable? please email me with your responce to . Thank you so much. Hi Age Formula In cell A1 put the Date of birth, in B1 put this formula =TODAY(), in C1 put this formula =DATEDIF(A1,B1,"y") -- Paul Sheppard ------------------------------------------------------------------------ Paul Sheppard's Profile: http://www.excelforum.com/member.php...o&userid=24783 View this thread: http://www.excelforum.com/showthread...hreadid=476039 |
#3
|
|||
|
|||
Hi
One way =DATEDIF(DOB,Today(),"y") to return years =DATEDIF(DOB,Today(),"ym") to return months =DATEDIF(DOB,Today(),"md") to return days where DOB represents the cell containing Date of Birth. =DATEDIF(DOB,Today(),"y")&" years "&DATEDIF(DOB,Today(),"ym")&" months "&DATEDIF(DOB,Today(),"md")&" days" Regards Roger Govier Age Formula?? wrote: hi I was wondering if anyone had a solution? I have a formula cell with a date of birth and a cell with the date now, and i wanted to know whether i could work out a cell to work out a formula for excel to work out an age, and automatically change with the current date. Is this at all possable? please email me with your responce to . Thank you so much. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I use fill hand to copy the fomula in this case? | Excel Discussion (Misc queries) | |||
To copy fomula | Excel Worksheet Functions | |||
a fomula for an entire column | Excel Discussion (Misc queries) | |||
stop automatically changing fomula ... | Excel Worksheet Functions | |||
How to get cell value with the ID from a fomula? | Excel Discussion (Misc queries) |