EOMONTH

This function will show the last day of the month which is a specified number of months before or after a given date.

The Syntax of the function is as follows:

EOMONTH(start_date, months)

start-date:  The starting date. start-date is a date/time value.

months: The number of months before or after the starting date. months is a number value. A negative months is used to specify a number of months before the starting date and a positive months is used to specify a number of months after the starting date.

Example 1:

Cell A1 contain the start_date, to get to the end of month we have used the 0 in the months argument, Similarly we have used the -1 to get to the end of the previous month.

to get the end of next month from the current date is we are using the 1 in the months argument

 

More about Dates

We are looking into some more Weekday formula in addition to my earlier blog post about Weekday function.

In this example we are identifying  the first and last weekdays using the Weekday, Month, Date & MOD function in Google Docs Speadsheets.

The Chosen date is in cell B1,

the link to my earlier Weekday function