# Leap Year

1. ## Leap Year

Hi! Kindly Provide me formula to check whether 2007,2008,...... are leap year or not

Thanks n reagrds

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

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

3. 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")

4. Try this,

``Please Login or Register  to view this content.``

5. ## Is 1700, 1800, 1900, 2100 the leap year ?

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!

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")))

6. ## Cross posting

Hi folks,

same question by same author here :

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

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

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1