ASSIGNMENT – 41

ANSWER KEY – USE OF DATEDIF: AGE CALCULATION

Current Date Used for Answer Key:

07-10-2026

In Excel, use TODAY() instead of entering this date manually.

Q1. How Many Students Are in the List?

Formula

=COUNTA(B2:B11)

Answer:

10 Students

Q2–Q5. Complete Age Calculation

Name Date of Birth Years Months Days Complete Age
Aarav 15-05-1998 28 4 22 28 Years, 4 Months and 22 Days
Meera 20-08-2001 25 1 17 25 Years, 1 Month and 17 Days
Rahul 10-10-2005 20 11 27 20 Years, 11 Months and 27 Days
Pooja 25-03-1995 31 6 12 31 Years, 6 Months and 12 Days
Karan 12-07-2008 18 2 25 18 Years, 2 Months and 25 Days
Simran 18-11-1999 26 10 19 26 Years, 10 Months and 19 Days
Mohit 05-02-2010 16 8 2 16 Years, 8 Months and 2 Days
Neha 22-09-2003 23 0 15 23 Years, 0 Months and 15 Days
Arjun 30-01-1990 36 8 7 36 Years, 8 Months and 7 Days
Priya 14-06-2006 20 3 23 20 Years, 3 Months and 23 Days

Q2. Completed Years

Formula

=DATEDIF(C2,TODAY(),"y")

Copy the formula down.

Answers:

  • Aarav → 28

  • Meera → 25

  • Rahul → 20

  • Pooja → 31

  • Karan → 18

  • Simran → 26

  • Mohit → 16

  • Neha → 23

  • Arjun → 36

  • Priya → 20

Q3. Completed Months After Completed Years

Formula

=DATEDIF(C2,TODAY(),"ym")

Answers:

  • Aarav → 4 Months

  • Meera → 1 Month

  • Rahul → 11 Months

  • Pooja → 6 Months

  • Karan → 2 Months

  • Simran → 10 Months

  • Mohit → 8 Months

  • Neha → 0 Months

  • Arjun → 8 Months

  • Priya → 3 Months

Q4. Remaining Days

Formula

=DATEDIF(C2,TODAY(),"md")

Answers:

  • Aarav → 22 Days

  • Meera → 17 Days

  • Rahul → 27 Days

  • Pooja → 12 Days

  • Karan → 25 Days

  • Simran → 19 Days

  • Mohit → 2 Days

  • Neha → 15 Days

  • Arjun → 7 Days

  • Priya → 23 Days

Q5. Complete Age in One Cell

Formula

=DATEDIF(C2,TODAY(),"y")&" Years, "&DATEDIF(C2,TODAY(),"ym")&" Months and "&DATEDIF(C2,TODAY(),"md")&" Days"

Answers:

Aarav: 28 Years, 4 Months and 22 Days

Meera: 25 Years, 1 Month and 17 Days

Rahul: 20 Years, 11 Months and 27 Days

Pooja: 31 Years, 6 Months and 12 Days

Karan: 18 Years, 2 Months and 25 Days

Simran: 26 Years, 10 Months and 19 Days

Mohit: 16 Years, 8 Months and 2 Days

Neha: 23 Years, 0 Months and 15 Days

Arjun: 36 Years, 8 Months and 7 Days

Priya: 20 Years, 3 Months and 23 Days

Q6. Age Status – Adult or Minor

Formula

=IF(D2>=18,"Adult","Minor")

Result

Name Age Status
Aarav 28 Adult
Meera 25 Adult
Rahul 20 Adult
Pooja 31 Adult
Karan 18 Adult
Simran 26 Adult
Mohit 16 Minor
Neha 23 Adult
Arjun 36 Adult
Priya 20 Adult

Answer:

9 Adults
1 Minor

Q7. How Many Students Are 20 Years or Older?

Formula

=COUNTIF(D2:D11,">=20")

Answer:

9 Students

They are:

Aarav, Meera, Rahul, Pooja, Simran, Neha, Arjun and Priya.

Correction: Karan is also 18, and Mohit is 16, so the complete list of 20+ students is:

  • Aarav

  • Meera

  • Rahul

  • Pooja

  • Simran

  • Neha

  • Arjun

  • Priya

Therefore, the correct answer is 8 Students.

Q8. How Many Students Are 25 Years or Older?

Formula

=COUNTIF(D2:D11,">=25")

Students:

  • Aarav – 28

  • Meera – 25

  • Pooja – 31

  • Simran – 26

  • Arjun – 36

Answer:

5 Students

Q9. Pooja’s Exact Age

Pooja’s Date of Birth:

25-03-1995

As of 07-10-2026:

Years

=DATEDIF(C5,TODAY(),"y")

31 Years

Months

=DATEDIF(C5,TODAY(),"ym")

6 Months

Days

=DATEDIF(C5,TODAY(),"md")

12 Days

Final Answer:

Pooja is 31 Years, 6 Months and 12 Days old.

Q10. PRACTICAL CHALLENGE

Create one Age Details column.

Formula

=B2&" is "&DATEDIF(C2,TODAY(),"y")&" Years, "&DATEDIF(C2,TODAY(),"ym")&" Months and "&DATEDIF(C2,TODAY(),"md")&" Days old – "&IF(D2>=18,"Adult","Minor")

Example Results

Aarav is 28 Years, 4 Months and 22 Days old – Adult

Meera is 25 Years, 1 Month and 17 Days old – Adult

Rahul is 20 Years, 11 Months and 27 Days old – Adult

Pooja is 31 Years, 6 Months and 12 Days old – Adult

Karan is 18 Years, 2 Months and 25 Days old – Adult

Simran is 26 Years, 10 Months and 19 Days old – Adult

Mohit is 16 Years, 8 Months and 2 Days old – Minor

Neha is 23 Years, 0 Months and 15 Days old – Adult

Arjun is 36 Years, 8 Months and 7 Days old – Adult

Priya is 20 Years, 3 Months and 23 Days old – Adult

EXTRA PRACTICE

1. Who is the Oldest Student?

Arjun – 36 Years

2. Who is the Youngest Student?

Mohit – 16 Years

3. How Many Students Are Adults?

=COUNTIF(G2:G11,"Adult")

Answer: 9

4. How Many Students Are Minors?

=COUNTIF(G2:G11,"Minor")

Answer: 1

5. Students Aged 20 to 24 Years

The students in this age range are:

  • Rahul – 20

  • Neha – 23

  • Priya – 20

Answer:

3 Students

FINAL ANSWER SUMMARY

Question Answer
Q1 10 Students
Q2 Years calculated using DATEDIF(...,"y")
Q3 Months calculated using DATEDIF(...,"ym")
Q4 Days calculated using DATEDIF(...,"md")
Q5 Complete Age created using DATEDIF + TODAY + &
Q6 9 Adults, 1 Minor
Q7 8 Students are 20+
Q8 5 Students are 25+
Q9 Pooja → 31 Years, 6 Months, 12 Days
Q10 Age Details using DATEDIF + TODAY + IF + &

Important Excel Concept

DATEDIF के तीन सबसे important age units:

"y"  → Completed Years
"ym" → Remaining Completed Months
"md" → Remaining Days

और TODAY() लगाने से पूरा assignment automatically current date के अनुसार update होता रहेगा.

PreviousNext