Determining whether a year is a leap year To determine whether a - TopicsExpress



          

Determining whether a year is a leap year To determine whether a particular year is a leap year, you can write a formula that determines whether the 29th day of February occurs in February or March. You can take advantage of the fact that Excel’s DATE function adjusts the result when you supply an invalid argument — for example, a day of 29 when February contains only 28 days. The following formula returns TRUE if the year of the date in cell A1 is a leap year; otherwise, it returns FALSE: =IF(MONTH(DATE(YEAR(A1),2,29))=2,TRUE,FALSE)
Posted on: Sun, 30 Jun 2013 05:54:59 +0000

Trending Topics



Recently Viewed Topics




© 2015