Formula subtracting months from a set date

  • Thread starter Thread starter coastal
  • Start date Start 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
 
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:
 
=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.
 
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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Expanding Date formula 1
FORMULA NEEDED FOR MONTHS 1
Subtracting dates from two columns 5
Excel Subtracting multiple columns from another column 3
subtract years and months (as in ages) from another age 3
changed DOB to age, but if no DOB need cell to be empty. 4
Hello happy new year to all, Text box input for year of purchase 0
Excel formulas + subtraction of days 2

Back
Top