Leap Year Calculator


We know 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, 2500, 2600
This is because they are evenly divisible by 100 but not by 400. 

 The following years are leap years:
1600, 2000, 2400
This is because they are evenly divisible by both 100 and 400. 

How to determine whether a year is a leap year

To determine whether a year is a leap year, follow these steps:
  1. If the year is evenly divisible by 4, go to step 2. Otherwise, go to step 5.
  2. If the year is evenly divisible by 100, go to step 3. Otherwise, go to step 4.
  3. If the year is evenly divisible by 400, go to step 4. Otherwise, go to step 5.
  4. The year is a leap year (it has 366 days).
  5. The year is not a leap year (it has 365 days).

Formula to determine whether a year is a leap year

Use the following formula to determine whether the year number that is entered into a cell (in this example, cell A1) is a leap year:

=IF(OR(MOD(A1,400)=0,AND(MOD(A1,4)=0,MOD(A1,100)<>0)),"Leap Year", "NOT a Leap Year")

 If the value in cell A1 is this        The formula returns
   ----------------------------------------------------------
   1992                                   Leap Year
   2000                                   Leap Year
   1900                                   NOT a Leap Year

Comments

Post a Comment

Popular posts from this blog

PDF form validation using javascript

Step-1 - Go to Forms menu-   Choose Add or Edit fields Step-2 - Double click to open the dialogue box of Properties of the selected   Field. Step-3 - Tooltip- give the name here of the selected field and then * (for ex- Full Name*) then click on Close . [NOTE- Here this is compulsory to write the ‘*’ after the field name] This step will be done separately and repeated as same for all the fields in the form. Step-4 - Then select the button (Print button), right click on it. Step-5 -   Go to Action Tab- Delete the existing Action from the Actions , and Add an Action- ·       Select Trigger- Mouse up ·       Select Action- Run a JavaScript (from the dropdown arrow) ·       Then click on Add- (a dialogue box will be opened) Write here -    validateFields(); ·       Then click on OK. ·       Then close this box. Step-6 -   Now go to Advanced Menu- select the Document Processing - then select   JavaScript Editor – firstly clear all the existing text or history. and paste here- (past
Read more

CSS Mouse Cursors and Custom Cursors

Image
<p style="color:red;"> <span style="cursor:crosshair;">crosshair cursor</span> <span style="cursor:wait;">wait cursor</span> <span style="cursor:help;">help cursor</span> </p> SS2.1 Cursor Styles auto The UA determines the cursor to display based on the current context. col-resize Indicates the item or column can be resized horizontally. crosshair A simple crosshair (e.g., short line segments resembling a "+" sign). default The platform-dependent default cursor. Often rendered as an arrow. help Help is available for the object under the cursor. Often rendered as a question mark or a balloon. move Indicates something is to be moved. not-allowed Indicates that the requested action will not be carried out. pointer The cursor is a pointer that indicates a link. row-resize Indicates the item or row can be resized vertically. text Indicates text that may be selected. Often rendered as an I-beam
Read more