DATEDIF Function

Function Type:

Date and Time

Description:

DATEDIF function calculates the number of days, months, or years between two dates. This function is useful in formulas where you need to calculate an age.
In my head, DATEDIF is short for Date Difference (Difference between Dates).

Function Structure:

=DATEDIF(start_date, end_date, unit)

Argument Breakdown:

start_date - Start date in Excel (date can be serial number format)

end_date - End date in Excel or Google Sheets (date can be serial number format)

unit - The time unit to use (years "Y", months "M", or days "D")

Example:

Days

Months

Years

Still need help with Excel and Google Sheets?

Get Instant Expert Help in Fiverr or PeoplePerHour platforms. Click one icon below.

We can also accept LEO, HIVE, HBD tokens as payment if we transact directly here in HIVE network.

This post is designated as a reviewer for Excel trainings I conduct.

Feel free to share with anyone. 😉

Earnings from Upvotes on this post are used to continue sharing Excel knowledge.
If you also want to earn HIVE in 7 days while blogging your favorite topics, join us here at Peakd.
*Thumbnail used is made in Canva