Calculating age to update automatically
Posted by simone on October 16, 2001 4:33 AM
I'd like to create a spread sheet that will automatically update a persons age each time it is opened. Help!
Posted by Dan on October 16, 2001 4:53 AM
This seems to work -
If the birthdate is in A1, in B1 enter:
=Today()-(A1-1)
Then right click on B1, choose Format Cells. Under Number, choose Custom and enter yy in the Type field. HTH.
Posted by Paul on October 16, 2001 5:51 AM
Or try =DATEDIF(A1,NOW(),"y")&"y,"&DATEDIF(A1,NOW(),"ym")&"m,"&DATEDIF(A1,NOW(),"md")&"d"
Posted by Al on October 17, 2001 7:40 PM
="Age is "&DATEDIF(A3,TODAY(),"y")&" Years, "&DATEDIF(A3,TODAY(),"ym")&" Months and "&DATEDIF(A3,TODAY(),"md")&" Days"
Posted by Al on October 17, 2001 7:41 PM
="Age is "&DATEDIF(A3,TODAY(),"y")&" Years, "&DATEDIF(A3,TODAY(),"ym")&" Months and "&DATEDIF(A3,TODAY(),"md")&" Days"
