To calculate your exact age: subtract your birth year from the current year, adjust for whether your birthday has passed this year, then count remaining months and days. Or enter your birthday into the age calculator and get the answer in 2 seconds.
Done. Handles leap years, month-end dates, and century boundaries automatically. If you need to know your age on a specific date (not today), change the "Calculate Age On" field.
Skip the manual math. Exact age in seconds.
Open Age CalculatorHere is how to calculate exact age by hand, using the example: born March 20, 1990, calculating on April 4, 2026.
Current year minus birth year: 2026 - 1990 = 36. Has your birthday passed this year? March 20 is before April 4 — yes, birthday has passed. Full years: 36.
If your birthday had NOT passed yet (e.g., calculating on March 10), subtract 1: 35 years.
From your last birthday (March 20, 2026) to today (April 4, 2026). March 20 to April 4 is 0 full months (you have not yet hit April 20).
From March 20 to April 4: 11 days in March (20th to 31st) + 4 days in April = 15 days.
Result: 36 years, 0 months, 15 days.
If your birthday is in cell A1:
| What You Want | Excel Formula | Example Result |
|---|---|---|
| Age in years | =DATEDIF(A1, TODAY(), "Y") | 36 |
| Remaining months | =DATEDIF(A1, TODAY(), "YM") | 0 |
| Remaining days | =DATEDIF(A1, TODAY(), "MD") | 15 |
| Total days alive | =TODAY() - A1 | 13,164 |
| Age as decimal | =(TODAY() - A1) / 365.25 | 36.04 |
Warning: DATEDIF is an undocumented Excel function inherited from Lotus 1-2-3. The "MD" parameter has known bugs when the birth day is 29, 30, or 31 and the current month is shorter. For month-end birthdays, verify results with a calculator.
| Scenario | Correct Age | Common Mistake |
|---|---|---|
| Born Dec 31, calculating Jan 1 next year | 0 years, 0 months, 1 day | Saying "1 year old" |
| Born Feb 29 (leap year), today is Feb 28 (non-leap) | Not yet your birthday | Saying you turned a year older on Feb 28 |
| Born Jan 31, calculating Mar 3 | 1 month, 3 days (via Feb 28) | Counting 1 month, 0 days |
| Born in 2000, calculating in 2026 | 26 years | Counting 2000 as "year 1" and getting 27 |
| Today is your birthday | You are now the new age | Some say "still" the old age until midnight |
Once you know your total days alive, you can convert to any unit:
Use the date calculator for the exact day count, then multiply.
Exact age, any birthday, any target date. No math needed.
Open Age Calculator