More Excel help required - HotUKDeals
We use cookie files to improve site functionality and personalisation. By continuing to use HotUKDeals, you accept our cookie and privacy policy.
Get the HotUKDeals app free at Google Play

Search Error

An error occurred when searching, please try again!

Login / Sign UpSubmit

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
sancho1983 Avatar
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
sancho1983 Avatar
8y, 2m agoPosted 8 years, 2 months ago
Options

All Comments

(3) Jump to unreadPost a comment
Comments/page:
#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

Post a Comment

You don't need an account to leave a comment. Just enter your email address. We'll keep it private.

...OR log in with your social account

...OR comment using your social account

Thanks for your comment! Keep it up!
We just need to have a quick look and it will be live soon.
The community is happy to hear your opinion! Keep contributing!