Leap Year

Try this, with your date in A1, put this in B1

=IF(MONTH(DATE(YEAR(A27),2,29))=2,TRUE,FALSE)

Thanks Buddy,


I know that one but in my problem i have only Year like 2004,2007 so I done that way from myself n it work....

IF(MOD(H21,4)=0,"LeapYear","false")

Try this,

Please Login or Register  to view this content.

Be Careful about the year end with 00

There is the forgot 1 rule about leap year.

If the year end with 00 be sure that it's the leap year by divided year with 400 and the remainder is 0!

for more information about the Check Leap year rule please see:
http://www.infoplease.com/spot/leapyear1.html
http://www.infoplease.com/spot/leapyear2.html

so the correct formula is

=IF(MOD(YEAR(CellRef),400)=0,"Leap year",
IF(AND(RIGHT(YEAR(CellRef),2)="00",MOD(YEAR(CellRef),400)<>0),"Not leap year",
IF(MOD(YEAR(CellRef),4)<>0,"Not leap year","Leap Year")))

Hi folks,

same question by same author here :

http://www.mrexcel.com/board2/viewtopic.php?t=289703

Thanks for the info nattasiray, I was unaware of that one, and also arthurbr for the cross post