Mega Code Archive

 

Categories / MSOfficeExcel 2007 Tutorial / Date Time Functions

 

Determining Whether a Year Is a Leap Year

Input the formula: =IF(MONTH(DATE(YEAR(A1),2,29))=2,TRUE,FALSE)