It comes up as 5545 instead of 58 yrs,7 mos. (58.58). I tried to change the
formating but it's not coming up correctly. Is there anything else I can do?
"Mangesh Yadav" wrote:
Then you simply need to subtract the earlier date from the recent, and
format as number.
=A1-B1
Mangesh
"junepbug" wrote in message
...
My version of Excel does not have the "DATEIF" function. I was bale to cut
and paste the formula in, and it works fine. However it dispays the
results
as Xyears, Xmonths, Xdays. I used to have it displayed as a four digit
(##.##) number, which made finding the average age eay. Any suggestions on
how to get that format back?
"Mangesh Yadav" wrote:
There's been a big discussion on this already.
http://excelforum.com/showthread.php...light=bluenose
Mangesh
"Vic Sowers" wrote in message
...
"ertug" wrote in message
...
"devinm21" wrote:
If I have a person's birthday, how can I calculate their current
age
based on
today's date?
Thanks!
In whole years:
=YEAR(NOW())-YEAR(A1)-IF(MONTH(NOW())MONTH(A1),0,IF(MONTH(NOW())MONTH( A1),
1,IF(DAY(NOW())<DAY(A1),1,0)))