Excel Age Calculator

[Cathy123]

I need to develop an age calculator like https://www.easycalculation.com/date-day/age-calculator.php in excel. How to develop it..Kindly help me ?

 

[royUK]

What have you tried so far?

Look at the DateDif function

 

[azumi]

Hi there, please see this Im make this formula based on your site links:

https://www.dropbox.com/s/uhevsycdh9y4zv2/Age Calculation-Az.xlsx?dl=0

hope this help

see u

 

[dave3009]

Slight variation on azumis post using datedif(). These are based on the cells used in the download but are a few columns to the right.

Excel 2007
	D
11	13 Years 8 months 26 days
12
13	5019 Days
14
15	120456 Hours
16
17	7227360 Minutes
Sheet1

Cell Formulas
Range	Formula
D11	=DATEDIF(DATE($C$9, $B$9, $A$9),DATE($C$5, $B$5, $A$5),"y")&" Years "&DATEDIF(DATE($C$9, $B$9, $A$9),DATE($C$5, $B$5, $A$5),"ym")&" months "&DATEDIF(DATE($C$9, $B$9, $A$9),DATE($C$5, $B$5, $A$5),"md")&" days"
D13	=DATE($C$5, $B$5, $A$5)-DATE($C$9, $B$9, $A$9)&" Days "
D15	=(DATE($C$5, $B$5, $A$5)-DATE($C$9, $B$9, $A$9))*24&" Hours "
D17	=(DATE($C$5, $B$5, $A$5)-DATE($C$9, $B$9, $A$9))*1440&" Minutes "

Hope this might also be of use.

Dave

 

[barry houdini]

Also if you want to get the "Number of days until next birthday" from that calculator you can use this formula

=IF(AND(B9=B5,A9=A5),"Happy Birthday!",DATE(C9+1,B9+DATEDIF(DATE(C9,B9,A9),DATE(C5,B5,A5),"y")*12,A9)-DATE(C5,B5,A5)&" days left for your next birthday")

 

[royUK]

This simulates the web site

Birthday calculator

 

[dave3009]

Although the OP has plenty of options for age formulas you happen to have missed that one out on your file royUK

 

[royUK]

I must have deleted it by accident. It was the first formula that I added.

Anyway it's back now.