EOMONTH()

The below formula will help you get the last day of the month for the date you select.

=EOMONTH(cell,0)

Cell : Cell is cell containing dates.

If you want previos months last date than -1 instead on 0.
Same way for next month +1.