Suppose, you are given a date say 10/22/14 (MM/DD/YY) and we want to have the last date of the month for the given date. Hence, you needs an answer of 10/31/14. The formulas to be used in this case –
=EOMONTH(A1,0)
=DATE(YEAR(A1),MONTH(A1)+1,0)
=DATE(YEAR(A1),MONTH(A1)+1,1)-1