DAYS
Calculates the number of days between two dates.
Syntax:
=DAYS(end_date,start_date)
Example:
Start Date: 01-Sep-2026
End Date: 28-Sep-2026
=DAYS(B2,A2)
Result: 27 days
DATEDIF
Calculates the difference between two dates in years, months, or days.
Syntax:
=DATEDIF(start_date,end_date,unit)
Common Units
|
Unit |
Meaning |
|
“Y” |
Complete Years |
|
“M” |
Complete Months |
|
“D” |
Total Days |
|
“YM” |
Remaining Months |
|
“MD” |
Remaining Days |
Age Example
DOB: 02-Sep-1985
As On Date: 28-Sep-2026
=DATEDIF(A2,B2,”Y”)
Result: 41 years
Practice
Calculate:
- Age in complete years
- Age in complete months
- Total number of days