The last day of the month equals the zero'th of next month for some strange reason, so this formula is like the EOMONTH function: =DATE(YEAR(A1),MONTH(A1)+1,0)