| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel functions
What function should I use to calculate the age of a person?
|
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Excel functions
Assumes DOB is in A1
=DATEDIF(A1,TODAY(),"Y") & " Years, " & DATEDIF(A1,TODAY(),"YM") & " Months, " & DATEDIF(A1,TODAY(),"MD") & " Days" "Rodica" wrote: What function should I use to calculate the age of a person? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Excel functions
On Feb 1, 2:47 pm, Mike wrote:
Assumes DOB is in A1 =DATEDIF(A1,TODAY(),"Y") & " Years, " & DATEDIF(A1,TODAY(),"YM") & " Months, " & DATEDIF(A1,TODAY(),"MD") & " Days" "Rodica" wrote: What function should I use to calculate the age of a person?- Hide quoted text - - Show quoted text - =DATEDIF(A1,TODAY(),"Y")&" Years, "&DATEDIF(A1,TODAY(),"YM")&" Months" |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Date Functions in Excel | Excel Worksheet Functions | |||
| How do I see the formula calculation used in Excel functions box | Excel Worksheet Functions | |||
| Improved Excel functions curve fitting in sheet | Excel Worksheet Functions | |||
| Are there functions that perform robust statistics in Excel? | Excel Worksheet Functions | |||
| Excel Range Value issue (Excel 97 Vs Excel 2003) | Excel Discussion (Misc queries) | |||
Linear Mode
