Excel Joining Experience Formula

 

Calculate Exact Age in Excel (Years, Months & Days)

If you want to calculate someone’s exact age from their Date of Birth, Excel can do it with a simple formula.

The Formula

=DATEDIF(A7,TODAY(),"Y")&" Years, "&DATEDIF(A7,TODAY(),"YM")&" Months, "&DATEDIF(A7,TODAY(),"MD")&" Days"

Example

Date of Birth	Age
15-Mar-1995	31 Years, 11 Months, 24 Days

(Result depends on today's date)

---

How the Formula Works

This formula combines three DATEDIF calculations and joins them using & (concatenation).

1️⃣ Years

DATEDIF(A7,TODAY(),"Y")

Returns the complete number of years between the date in A7 and today.

Example:

31

---

2️⃣ Months

DATEDIF(A7,TODAY(),"YM")

Returns the remaining months after the completed years.

Example:

11

---

3️⃣ Days

DATEDIF(A7,TODAY(),"MD")

Returns the remaining days after the months.

Example:

24

---

4️⃣ Combining the Results

&" Years, "&
&" Months, "&
&" Days"

The & symbol joins text and numbers to create a readable result.

Final output:

31 Years, 11 Months, 24 Days

---

Why Use This Formula?

✅ HR employee age calculation
✅ Employee service duration
✅ Student age calculation
✅ Membership duration
✅ Automatic daily update (because of TODAY())

---

💡 Pro Tip

If you want to calculate work experience instead of age, just replace the Date of Birth with Joining Date.

Example:

Joining Date → Experience