April 13, 2012 Leave a comment
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:
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.
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