Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
tyniyvonne
 
Posts: n/a
Default how to get age using birthdate


  #2   Report Post  
 
Posts: n/a
Default

=(now()-bday)/365

-----Original Message-----

.

  #3   Report Post  
Frank Kabel
 
Posts: n/a
Default

Hi
see:
http://www.cpearson.com/excel/datedif.htm#Age

--
Regards
Frank Kabel
Frankfurt, Germany

"tyniyvonne" schrieb im
Newsbeitrag ...


  #4   Report Post  
Myrna Larson
 
Posts: n/a
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 06:58 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"