How to input birthdate field in Microsoft excel?

Asked By Jorge Millicent 10 points N/A Posted on - 03/08/2012

We need to count birthday field into an age field in Microsoft excel, 

Which clue can we use to calculate Birth date into an age field in Microsoft excel?

• Status: Open
• Question Views: 1145
• Answer Count: 2
• Vote Up 0 Vote Down

• Answer Accepted: Yes
• Question Category: MS Excel

Best Answer by Fabros Almonia

Go To Solution

Best Answer

Best Answer

Answered By Fabros Almonia 0 points N/A #120243

How to input birthdate field in Microsoft excel?

Dear Jorge,

To know the age of a given birth date in excel using the formula given below:

=DATEDIF(A2,TODAY(),"y")&" years "&DATEDIF(A2,TODAY(),"ym")&" months "&DATEDIF(A2,TODAY(),"md")&" days"

For example see the figure below, the first column has birthdays listed and the second has the age to be calculated:

Enter = in the second cell of the Age column and paste the above formula as shown:

On the status bar you can see the formula and in age column you can see the age according to the date in column A.

Copy the same formula in all the cells and the age will be calculated accordingly.

About Fabros Almonia

Questions
3

Answers
30

Best Answers
5

• Vote Up 0 Vote Down

• Posted on - 03/10/2012
• Question Category: MS Excel

Answered By Sherin Viluel 0 points N/A #120245

How to input birthdate field in Microsoft excel?

In Microsoft excel, you can use the following method for calculating the age which related to each birthday. In this method I assumed that you want to calculate the age of the data as of 06/16/2012.

As shown in the above picture I have typed the following formula in the “D2” Cell and drag or copy the same formula to the next rows (Those are D3, D4D5 etc.). (You can see the formula it on the formula bar).

The formula is “= (C2-B2)/365”.

In order to get the above result you have to meet the following conditions.

Column B and C should be in the date format.

Column D should be in the General format.

About Sherin Viluel

Questions
0

Answers
50

Best Answers
37

• Vote Up 0 Vote Down

• Posted on - 06/16/2012
• Question Category: MS Excel