More Excel help required

3 replies
Found 20th Apr 2009
Anybody feel like helping me out with Excel stuff?

At the moment I have a table where I input a DOB and it works out the age

=YEAR(NOW())-YEAR(B2)-IF(MONTH(B2)>MONTH(NOW()),1,IF(MONTH(B2)=MONTH(NOW()),IF(DAY(B2)>DAY(NOW()),1,0)))

Where 'B2' is the DOB

Which is great, now I want it to display the age of the person on Sept 1st 2008, must be less complicated than the one i have, but can't for the life of me work it out!!

Thanks in advance, rep given obviously

  1. Misc
Groups
  1. Misc
3 Comments

just tried that, but it dont work?

Original Poster

=YEAR(NOW())-YEAR(B2)-IF(MONTH(B2)>MONTH(NOW()),1,IF(MONTH(B2)=MONTH(NOW()),IF(DAY(B2)>DAY(NOW()),1,0)))

Strange, that's definitely what i've just copied from the spreadsheet
Post a comment
Avatar
@
    Text
    Top Discussions
    1. School shoes - with lights33
    2. Gearbest: Order - Nowhere to be seen...89
    3. Advice on a cheaper hand held vacuum please.36
    4. Foo fighters presale code.3436

    See more discussions