Leap Year

[realsaggi]

Hi! All.

Kindly provide me the formula to calculate like 2007 is a leap year or not

Thanks & Regards

 

[realsaggi]

I find solution from myself only.. Thanks
=IF(MOD(H21,4)=0,"LeapYear","false")

 

[Richard Schollar]

Hi

Using the Gregorian calendar, that formula need to be modified to take account of centennial years not being evenly divisible by 400 (eg 2000 is a leap year, but 1900 is not):

Excel Workbook
	A	B	C	D	E	F	G
1	2004	2000	1800	1900	1902	2100	1988
2	Leap Year	Leap Year	Not a Leap Year	Not a Leap Year	Not a Leap Year	Not a Leap Year	Leap Year
Sheet1

I'm sure there is a slicker way of writing this, but this should be fully functional.

 

[Norie]

Try this where A1 holds the year.

=IF(DAY(DATE(A1,2,29))=1,"Not a leap year", "Yep, it's a leaping!!")

 

[arthurbr]

Cross posting

http://www.excelforum.com/showthread.php?p=1820306&posted=1#post1820306