| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Calculate age
sorry typo
=DATEDIF(A1,TODAY(),"Y") & " Years, " & DATEDIF(A1,TODAY(),"YM") & " Months, " & DATEDIF(A1,TODAY(),"MD") & " Days" "Mike" wrote: with the DOB in A1 try =DATEDIF(A1,TODAY,"Y") & " Years, " & DATEDIF(A1,TODAY,"YM") & " Months, " & DATEDIF(A1,TODAY,"MD") & " Days" "Grd" wrote: Hi there, How do I calcuate the age of a person if all I have is their date of birth in a cell? Is this possible in excel? Thanks for your help Suzanne |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| calculate | Excel Worksheet Functions | |||
| How to calculate this | Excel Discussion (Misc queries) | |||
| How can I calculate.... | Excel Discussion (Misc queries) | |||
| How can i calculate only once? | Excel Discussion (Misc queries) | |||
| Calculate only if... | Excel Discussion (Misc queries) | |||
Threaded Mode
