Question Locked

Age Calculator

0 helpful
5 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
How do you find exact age in years, months, and days?

5 replies

by kees_b

I would do it in Excel. It's a quite simple formula there.

by coordineight8 edited

To calculate exact age in years, months, and days, start by subtracting the birth year from the current year, then adjust if the current month and day are before the birth date. Next, subtract the months, borrowing from the year if needed, and finally subtract the days, borrowing from the previous month if necessary while accounting for the correct number of days in each month. For example, if someone was born on May 10, 2000, and today is September 26, 2025, their exact age is 25 years, 4 months, and 16 days.

by hock4674 edited

To calculate exact age in years, months, and days, you basically subtract the birth date from today’s date step by step:

Subtract the years (current year − birth year).

If today’s month/day is earlier than the birth month/day, reduce the year by one and adjust.

Subtract the months, borrowing from the year if needed.

Subtract the days, borrowing from the previous month if necessary (while accounting for how many days that month had).

Example:

Birth date: May 10, 2000

Today: September 26, 2025

→ Years: 25
→ Months: 4
→ Days: 16

So the exact age = 25 years, 4 months, 16 days.

You can also use an age calculator tool or a small code snippet in Python, Java, or Excel to automate this.

by chahalmehak533 edited

1. Get the birth date and current date

For example:

Birth date:** 15 March 2000
Current date:** 27 September 2025

2. Calculate years

Subtract the birth year from the current year:

2025 - 2000 = 25 \text{ years}

If the current month/day hasn’t reached the birth month/day yet, subtract 1 year.

3. Calculate months

Subtract the birth month from the current month:

9 - 3 = 6 \text{ months}

If the current day is less than the birth day, subtract 1 month.

4. Calculate days

If the current day is greater than or equal to the birth day:

27 - 15 = 12 \text{ days}

If the current day is less than the birth day, borrow days from the previous month.

✅ Result

For the example above:

Exact age = 25 years, 6 months, 12 days

by gracemiller8477 edited

To find someone’s exact age in years, months, and days, subtract their birth date from the current date. First, calculate the difference in years by subtracting the birth year from the current year. Then adjust the months and days: if the current day is less than the birth day, borrow one month (using the previous month’s number of days) and subtract accordingly; if the current month is less than the birth month, subtract one year and add 12 to the month difference. This gives the precise age expressed as **X years, Y months, and Z days**.

This discussion is closed to new replies.