ASSIGNMENT – 35

ANSWER KEY – USE OF DATEDIF FORMULA

PART A – DATE DIFFERENCE

Given Dates

First Date: 15-01-2010
Second Date: 20-06-2020

Interval	Formula	Answer
Days	=DATEDIF(A2,B2,"d")	3,809 Days
Months	=DATEDIF(A2,B2,"m")	125 Months
Years	=DATEDIF(A2,B2,"y")	10 Years
Year-Days	=DATEDIF(A2,B2,"yd")	157 Days
Year-Months	=DATEDIF(A2,B2,"ym")	5 Months
Month-Days	=DATEDIF(A2,B2,"md")	5 Days

Q1. Total Number of Days

Formula

=DATEDIF(A2,B2,"d")

Answer: 3,809 Days

Q2. Total Number of Months

Formula

=DATEDIF(A2,B2,"m")

Answer: 125 Months

Q3. Total Number of Complete Years

Formula

=DATEDIF(A2,B2,"y")

Answer: 10 Years

Q4. Remaining Days After Completed Years

Formula

=DATEDIF(A2,B2,"yd")

Answer: 157 Days

This means after completing 10 full years, there are 157 additional days.

Q5. Remaining Months After Completed Years

Formula

=DATEDIF(A2,B2,"ym")

Answer: 5 Months

Q6. Remaining Days After Completed Months

Formula

=DATEDIF(A2,B2,"md")

Answer: 5 Days

Complete Difference:

15-01-2010 to 20-06-2020 = 10 Years, 5 Months and 5 Days

PART B – STUDENT AGE CALCULATION

Important

The following answers use:

TODAY() = 07-10-2026

Therefore, if students open the file on another date, their age will automatically change.

Q7. Current Age in Completed Years

Formula

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

Name	Date of Birth	Age in Years
Aarav	12-03-2005	21
Riya	25-07-2008	18
Karan	18-11-2003	22
Neha	05-02-2010	16
Rahul	21-09-2006	20
Simran	14-12-2004	21

Q8. Completed Months After Completed Years

Formula

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

Name	Completed Years	Remaining Months
Aarav	21	6
Riya	18	2
Karan	22	10
Neha	16	8
Rahul	20	0
Simran	21	9

Q9. Remaining Days After Completed Months

Formula

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

Name	Remaining Days
Aarav	25
Riya	12
Karan	19
Neha	2
Rahul	16
Simran	23

Q10. Complete Age Statement

Formula

=A2&" is "&DATEDIF(B2,TODAY(),"y")&" Years, "&DATEDIF(B2,TODAY(),"ym")&" Months and "&DATEDIF(B2,TODAY(),"md")&" Days old."

Answers as of 07-10-2026

Name	Age Statement
Aarav	Aarav is 21 Years, 6 Months and 25 Days old.
Riya	Riya is 18 Years, 2 Months and 12 Days old.
Karan	Karan is 22 Years, 10 Months and 19 Days old.
Neha	Neha is 16 Years, 8 Months and 2 Days old.
Rahul	Rahul is 20 Years, 0 Months and 16 Days old.
Simran	Simran is 21 Years, 9 Months and 23 Days old.

BONUS ANSWERS

Total Months

Formula:

=DATEDIF(B2,TODAY(),"m")

Name	Total Months
Aarav	258
Riya	218
Karan	274
Neha	200
Rahul	240
Simran	261

Total Days

Formula:

=DATEDIF(B2,TODAY(),"d")

Name	Total Days
Aarav	7,879
Riya	6,648
Karan	8,359
Neha	6,088
Rahul	7,321
Simran	7,967

Final Concept to Remember

DATEDIF Unit	Meaning
"d"	Total Days
"m"	Total Complete Months
"y"	Total Complete Years
"yd"	Days excluding complete years
"ym"	Months excluding complete years
"md"	Days excluding complete months

Most Important Age Formula

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

Years

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

Months

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

Days

Together, these three formulas give the exact age in Years, Months and Days.