EDATE Function

Purpose

Adds or subtracts a specified number of months from a date.

Syntax

=EDATE(start_date,months)

Example

Start Date	Months	Result
28-Sep-2026	3

Formula:

=EDATE(A2,B2)

Result:

28-Dec-2026

Uses

• Subscription expiry
• Loan schedules
• Contract renewal
• Installment dates

EOMONTH Function

Purpose

Returns the last day of a month.

Syntax

=EOMONTH(start_date,months)

Example:

=EOMONTH(A2,0)

If A2 is 28-Sep-2026, result:

30-Sep-2026

DATEDIF Function

Purpose

Calculates the difference between two dates.

Syntax

=DATEDIF(start_date,end_date,unit)

Common units:

Unit	Meaning
“Y”	Complete years
“M”	Complete months
“D”	Total days

Example — Employee Service

Joining Date: 15-Jan-2020
End Date: 28-Sep-2026

Years:

=DATEDIF(A2,B2,”Y”)

Months:

=DATEDIF(A2,B2,”M”)

Days:

=DATEDIF(A2,B2,”D”)

Practice

Calculate the service period of five employees.