EDATE function

Function Type:

Date and Time

Description:

EDATE function in Excel or Google Sheets is used to return the serial number of the date that is the indicated number of months before or after the start date.

Function Structure:

=EDATE(start_date,months)

Arguments

start_date - this is the date or serial number representing the start date

months - number of months after the start_date

• we can use negative number in this argument to get the date from previous months

Examples

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.