Formula subtracting months from a set date

C

coastal

I have a row of dates and I need a formula to tell me the age in years and
months of each client.

So I have

12/15/99
7/13/02
10/14/97

and Need ages from current date.
--coastal
 
M

Marcelo

hi

try it

=DATEDIF(A6,TODAY(),"y")&" years and "&DATEDIF(A6,TODAY(),"ym")&" months"

assuming the date of birth is on a6

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"coastal" escreveu:
 
D

David Biddulph

=DATEDIF(A2,TODAY(),"y")&" years "&DATEDIF(A2,TODAY(),"ym")&" months"
assuming that your dates really are numbers formatted as Excel dates, and
aren't text looking like dates.
 
C

coastal

Thanks! This did work!!!!
--
--coastal


David Biddulph said:
=DATEDIF(A2,TODAY(),"y")&" years "&DATEDIF(A2,TODAY(),"ym")&" months"
assuming that your dates really are numbers formatted as Excel dates, and
aren't text looking like dates.
Click to expand...
 
Top