In an excel spreadsheet, I have two columns: current age and current date. Read below...?

Question

The third column needs a formula that calculates the date that a particular child turns 3. What is this formula?

Answer 1

I think i have found the solution of your problem
The formula will be
DATE(YEAR(B5)+3,MONTH(B5),
DAY(B5))
Where B5 is Date of Birth.
Have a good time.

Answer 2

You should have a column that shows the birth date. In the fourth column then you can have this formula birthdate + (365 * 3). Format it using the date format and you should have the date. If there is a leap year in between then you have to add one day. It can get complicated if you really want an accurate formula because of the leap year.

[e-mail]

Answer 3

If A1 has 7/10/07 and B1 has 8/10/07, you've this formula in C1: =B1 - A1 this provides the answer of 31, obviously, on the grounds that July has 31 days. EDIT: be conscious, if the answer in C1 feels like a million/31/00, replace its format with format - Cells - volume tab - %. volume. .

Answer 4

=B1+((3*365)-(+A1*365))

Format the cell to date of choice. When entering the date use # of days old to calculate exact date of the third birthday.

Example: A 6 month old will be .5 years old. A 2 month old will be .16 years old (assuming two 30 day months).