ExcelBanter - Excel functions

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Excel functions (https://www.excelbanter.com/excel-worksheet-functions/128721-excel-functions.html)

Rodica

Excel functions

What function should I use to calculate the age of a person?

Mike

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?

Vinod Jain

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"

All times are GMT +1. The time now is 10:30 PM.