Site icon ExcelNotes

How to Get the Dates at a Certain Age

It sounds very simple and easy to get the date at a certain age if you know the birth date. For example, if a child was born on January 5, 2016, the date at the age of 2 would be January 5, 2018…..Month and Day keep the same and the year is changed.

When you have to deal with many records, instead of adding the number of years to each record, the formula below will do the work:

=DATE(YEAR(A2)+5, MONTH(A2), DAY(A2))

Where A2 is the cell with the birth date and you can change "5" to any years of age.

The above formula gives you the dates after an exact years, such as 2 years, 3 years… If you want to know the dates after certain years, months and days, please use the formula below:

=DATE(YEAR(A2)+5, MONTH(A2)+6, DAY(A2)+3)

The idea for this formula is to break down the birthday into years, months and days, and add each as required. For example, what are the dates after 5 years 6 months and 3 days?

In the formula, 5 represents 5 years, 6 represents 6 months, and 3 represents 3 days. You can change to any number based on the requirements.

When the month is over 12, it will automatically translate into years and months. For example, 14 months will be 1 year and 2 months.

Exit mobile version