EOMONTH function

EOMONTH Function

Function Type:

Date and Time


Description:

EOMONTH function in Excel or Google Sheets is used to return the serial number of the last day of the month before or after a specified number of months.


Function Structure: 

=EDATE(start_date,months)


Arguments 

start_date – this is the date or serial number representing the start date in a valid Excel serial number format.

months – number of months before or after the start_date

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

Examples 

EOMONTH function examples

Still need help with Excel and Google Sheets? Get Instant Expert Help in Fiverr or PeoplePerHour platforms. Click one icon below.

Get Instant Expert Help on Fiverr

Get Instant Expert Help in PeoplePerHour

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

or you can help me through https://www.buymeacoffee.com/cashheaven 😉


Back to Learn Excel->

Published by Cash Heaven

Excel Expert and Financial Analyst Excel / Google Sheets / Financial Modelling, Valuation and Analysis Effective communicator / High quality / Affordable / Reliable / Quick Turnover I've successfully completed over 200 financial modelling, valuation and analysis projects with start-up stage and corporate companies over the past 4 years. I love to solve problems, have an eye for design, and have built business excel templates. I fix Excel formulas in 10 minutes.

One thought on “EOMONTH function”

Leave a Reply

Discover more from CashHeaven

Subscribe now to keep reading and get access to the full archive.

Continue reading