H harsh_njoy Jul 25, 2008 #1 Hi, how we can calculate present age if date of birth is given say for eg: 21/2/1983 Thanks
N NoodNutt Jul 25, 2008 #2 G'day Harsh Assume A1 = Birthdate = 06-Mar-1960 Format as Date B1 = Now() = 25-Jul-2008 Format as Date C1 = (B1-A1)/365 = 48yo Format as Number HTH Mark.
G'day Harsh Assume A1 = Birthdate = 06-Mar-1960 Format as Date B1 = Now() = 25-Jul-2008 Format as Date C1 = (B1-A1)/365 = 48yo Format as Number HTH Mark.
J Joerg Mochikun Jul 25, 2008 #4 Assuming that A1 contains the birthday: =DATEDIF(A1,NOW(),"y") For more information on DATEDIF have a look at your *very* old Excel documentation (yes, Excel once came with printed handbooks) or look here:http://www.cpearson.com/excel/datedif.aspx Cheers, Joerg Lefeber
Assuming that A1 contains the birthday: =DATEDIF(A1,NOW(),"y") For more information on DATEDIF have a look at your *very* old Excel documentation (yes, Excel once came with printed handbooks) or look here:http://www.cpearson.com/excel/datedif.aspx Cheers, Joerg Lefeber
