Hello All,
When I am using sums to work out how old some one is from todays date to the date of birth. It isnt working out right for example if i was born on the 16/03/1988 and today being 04/05/2012 it is saying im 23 when i should be 24. anyone know how to get this calc to work out the correct date of birth 100% of the time?
Kind Regards
Ricky
I am getting 24 as the answer. What formula are you using?
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
Hi Ricky
One way is this.
=(TODAY()-A1)/365,25
A1, is your Birthday date.
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
=SUM((E24-E23)/365) this is the sum i have been using but it seems to be producing either one year to old or one year to young
pepe le mokko
thank you seems to be working
brilliant!
Fotis,
I guess you do not need the ,25 part of the formula. Excel does not accept it and changed it to "/36525".
Trywhere A1 holds your birth day
=DATEDIF(A1,today(),"y")
I just tried a lil different way. =today()-A1 (where A1 is the birthday) and custom formatted the answer as "yy".
Or try this ...
=DATEDIF(A1,TODAY(),"y")
If you need any more information, please feel free to ask.
However,If this takes care of your needs, please select Thread Tools from menu above and set this topic to SOLVED. It helps everybody! ....
Also
اس کی مدد کرتا ہے اگر
شکریہ کہنے کے لئے سٹار کلک کریں
If you are satisfied by any members response to your problem please consider using the small Star icon bottom left of their post to show your appreciation.
Thanks for agreeing with meOriginally Posted by Marcol
Or try this ...
=DATEDIF(A1,TODAY(),"y")
@ Arlette.
My logic, is this(One Excel Guru, explained to me some years ago and i angee with this)
If we do =TODAY()-A1, Then we get the numbers of dates.
We need to convert this number of days into a number of years. Most years have 365 days but every fourth year has 366 days. So the average number of years is 365.25.
I agree with you Fotis. Actually, as per your computer setting, you use "," instead of ".". I didnt change it at my end and hence the confusion.
@ moley165
Pepe's formula works perfectly and of course you can use it. But, just i want to say that mine, gives you the same result...
Have a nice day.
Never mind!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
moley165 
Register To Reply
Bookmarks