• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

HELP ! I can't get a formula right

P

PLM

New Member
I need a formula that will help me figure out how old a person will be as of a certain date. ie. the person birthday as Aug 2, 1966 - how old will the person be as of September 1, 2014. in years and months. can anyone help????
 
Last edited by a moderator:
Hi,
Try this in one cell to give the years (1st date in A1 and 2nd date in A2)

=YEAR(A2)-YEAR(A1)-(IF(MONTH(A2)>MONTH(A1), 0,IF(MONTH(A2)<MONTH(A1), 1, IF(DAY(A2)<DAY(A1), 1,0))))

and this in the next cell to give the months

=IF(MONTH(A2)<MONTH(A1), 12-(MONTH(A1)-MONTH(A2)), MONTH(A2)-MONTH(A1))
 
DOB(d/m/y) 01-Sep-2014 Age as of Sep'14 Age as of Jan'15 Age as of Sept '15
13-Dec-2010 01-Sep-2014 3 . 8 4 . 0 4 . 8
I think i still have it wrong
 
Luke M said:
Assuming your dates are in A2 and B2:
=DATEDIF(A2,B2,"Y")&" year(s) and "&DATEDIF(A2,B2,"ym")&" month(s)"
Click to expand...

DOB(d/m/y) 01-Sep-2014 Age as of Sep'14 Age as of Jan'15 Age as of Sept '15
13-Dec-2010 01-Sep-2014 3 . 8 4 . 0 4 . 8
 
Column A is the person's birthday
Column B is the date September 1, 2014
I need column C to be how old person will be on September 1, 2014

Sorry - I am not excel friendly or computer friendly either

what should the formula in column C be??
 
I'm not sure what you're numbers mean in posts #5 and 6. The formula I posted appears to work just fine.
upload_2014-10-29_15-57-12.png
Are you expecting a different result?
 
Assuming Birthday in A2 and some Date in B2:

=IF(DATEDIF(A2,B2,"y")=0,"",DATEDIF(A2,B2,"y")&" years ")&IF(DATEDIF(A2,B2,"ym")=0,"",DATEDIF(A2,B2,"ym")&" months ")&DATEDIF(A2,B2,"md")&" days"

this will also take care of 0 values for Year, month or days.

thanks.
 
You must log in or register to reply here.
Back
Top