Mega Code Archive

 

Categories / MSOfficeExcel 2007 Tutorial / Date Time Functions

 

Returns the number of days in a month

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