More Excel help required - HotUKDeals
Get the HotUKDeals app free at Google Play

#### Search Error

An error occurred when searching, please try again!

# More Excel help required

£0.00 @
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(… Read More
8y, 2m agoPosted 8 years, 2 months ago
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
8y, 2m agoPosted 8 years, 2 months ago
Options

(3)
#1
just tried that, but it dont work?
#2
=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