Home |
Search |
Today's Posts |
#1
|
|||
|
|||
how to get age using birthdate
|
#2
|
|||
|
|||
=(now()-bday)/365
-----Original Message----- . |
#3
|
|||
|
|||
Hi
see: http://www.cpearson.com/excel/datedif.htm#Age -- Regards Frank Kabel Frankfurt, Germany "tyniyvonne" schrieb im Newsbeitrag ... |
#4
|
|||
|
|||
Not quite....
Try it with birthdate of Dec 6, 1954. Check the age on each of the days from Nov 15 through Dec 10. This will also show you why adding the INT function doesn't correct the problem. PS: You can try 365.25, too, but it won't work. On Mon, 6 Dec 2004 07:55:44 -0800, wrote: =(now()-bday)/365 -----Original Message----- . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|