Using your phone's internet browser
go to:  qna.rediff.com
Click and drag this link to
the Home icon in your browser.
Q.

Kya koi bhi pure QnA me leap year ka formula nahi bata sakta hai???

Asked by surendra kumar, 09 Jan '12 01:06 pm
  Invite a friend  |  
  Save  |  
 Earn 10 points for answering
Answer this question  Earn 10 points for answering    
4000 characters remaining  
  
    
Keep me signed inNew User? Sign up

Answers (2)

 
1.

The date system that is used by Excel is based on the Gregorian calendar, first established in 1582 by Pope Gregory XIII. This calendar was designed to correct the errors introduced by the less accurate Julian calendar.

In the Gregorian calendar, a normal year consists of 365 days. Because the actual length of a sidereal year (the time required for the Earth to revolve once about the Sun) is actually 365.25635 days, a "leap year" of 366 days is used once every four years to eliminate the error caused by three normal (but short) years. Any year that is evenly divisible by 4 is a leap year: for example, 1988, 1992, and 1996 are leap years.

However, there is still a small error that must be accounted for. To eliminate this error, the Gregorian calendar stipulates that a year that is evenly divisible by 100 (for example, 1900) is a leap year only if it is also evenly divisible by 400.

For this reason, the following years are not leap years:
1700, 1800, 1900, 2100, 2200, 2300, ...more
Answered by iqbal seth, 09 Jan '12 01:06 pm

 
  
Report abuse
Useful
 (0)
Not Useful
 (0)
Your vote on this answer has already been received
2.

A year will be a leap year if it is divisible by 4 but not by 100. If a year is divisible by 4 and by 100, it is not a leap year unless it is also divisible by 400.

Thus years such as 1996, 1992, 1988 and so on are leap years because they are divisible by 4 but not by 100. For century years, the 400 rule is important. Thus, century years 1900, 1800 and 1700 while all still divisible by 4 are also exactly divisible by 100. As they are not further divisible by 400, they are not leap years.
Answered by Stone Heart, 09 Jan '12 01:08 pm

 
  
Report abuse
Useful
 (2)
Not Useful
 (0)
Your vote on this answer has already been received

Ask a Question

Get answers from the community

600 characters remaining