Mega Code Archive

 

Categories / MSOfficeExcel 2007 Tutorial / Date Time Functions

 

Determining the Last Day of a Month

Input the formula: =DATE(YEAR(A1),MONTH(A1)+1,0)