Calculate Date of Birth in Microsoft Excel

Asked By steelmatt 0 points N/A Posted on - 09/18/2011

I am using Microsoft Excel. You can see 2 figures in below picture. First is DOB (Date of Birth) and last is Some Even date. Now I want to calculate the passed time. Please tell me how can I do this? Also tell me its formula.

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

• Answer Accepted: Yes
• Question Category: MS Excel

Best Answer by Drothy

Go To Solution

Best Answer

Best Answer

Answered By Drothy 0 points N/A #124807

Calculate Date of Birth in Microsoft Excel

Hi!

MS Excel provides very dynamic calculations and formulas available to apply. Manipulation of dates was never such an easy task before the invention of MS Excel.

If you want to calculate the time passed during two different dates it is very much necessary to write both of the dates in the same format. The default format is dd/mm/yyyy. First of all write both of the dates in this format. Select the cell where you want to display the result of the formula. Press = then select the first date and then select the second date press enter.

Now the formula will be made automatically and will be displayed on formula bar at the top of the page. Now you can change the date and the time passed will change automatically.

Hope it helps.

About Drothy

Questions
0

Answers
21

Best Answers
11

• Vote Up 0 Vote Down

• Posted on - 09/18/2011
• Question Category: MS Excel

Answered By mathews.m 0 points N/A #124808

Calculate Date of Birth in Microsoft Excel

Hi,

We do have different formulas to calculate different functions. Whereas regarding your calculations you want to find the number of days you have passed on.

The formula is:

	A	B
1	15/08/88	Birthday
2	23	Age
3

The formula is= INT((TODAY()-A1/365.25)

Excel has a special function that if we type today in the formulas, it takes the current date .The number is used as 365.25 because all the years won't have 365 days.

About mathews.m

Questions
0

Answers
6

Best Answers
2

• Vote Up 0 Vote Down

• Posted on - 09/18/2011
• Question Category: MS Excel