Age Calculator

Age Calculator

Enter Formula in MS Excel

Enter your Date of Birth (DOB) here = (this cell location should be C5)
e.g. 1949/08/27

Age in years = Formula = =IF(C5>1,DOB!G14,"")
Age in months = Formula = =IF(C5>1,(DOB!G14*12),"")
Age in days = Formula = =IF(C5>1,(C15*365),"")
Age in hours = Formula = =IF(C5>1,(C17*24),"")
Age in minutes = Formula = =IF(C5>1,(C18*60),"")
Age in seconds = Formula = =IF(C5>1,(C19*60),"")
Age in Milli seconds = Formula = =IF(C5>1,(C20*100),"")
Age in weeks = Formula = =IF(C5>1,(C17*7),"")
You born on = Formula = =IF(C25=16,"",C24)