DW makes a function to determine the leap year of the common year

Leap years are the Gregorian calendar and are only for the 28th and 29th of February!!

Leap year judgment: 1. Either a whole hundred years can be divisible by 4 or a leap year.

2. It is a leap year that can be divisible by 400 for a whole hundred years.

Let me give you a detailed introduction to the leap month:

As a lunisolar calendar, the number of days in the month is determined according to the monthly wancing, and the time of the year is based on 12 months, and the normal year is about 11 days less than the return year. In order to coincide with the Earth's cycle around the Sun, i.e., the return year, one month is added every 2 to 4 years, and the additional month is a leap month. The month to which the leap month is added is inferred from the rules of the lunar calendar, and is mainly determined according to the correspondence with the 24 solar terms of the lunar calendar.

There are 13 months in a year with a leap month and a calendar year length of 384 or 385 days, which is also known as a leap year. For example, in the lunar calendar of the Year of the Rat in 1984, there were two Octobers, usually the first October and the last October (i.e. leap month). The calculation of leap months in leap years in the lunar calendar is one leap in 3 years, two leaps in 5 years, and seven leaps in 19 years; The lunar calendar is basically a cycle of 19 years, corresponding to the same time in the Gregorian calendar.

For example, May 27, 2001, May 27, 1982 and May 27, 1963 in the Gregorian calendar are all the fifth days of the fourth month of the leap month.

Comparison table of leap months from 1982 to 2042 in the Gregorian calendar and leap years in the lunar calendar:

May 23, 1982 Leap April Minor Year of Renwu.

November 23, 1984 Leap October Jiazi year.

July 26, 1987 Leap June.

June 23, 1990 Leap May, Great Geng Wu Year.

April 22, 1993 Leap March Lunar New Year.

September 25, 1995 Leap August

June 24, 1998 Leap May.

May 23, 2001 Leap April Great Xin Si Year.

March 21, 2004 Leap February.

August 24, 2006 Leap Month Seventh Year of Propion.

June 23, 2009 Leap May is the year of the ugly one.

May 21, 2012 Leap April Year of the Lunar New Year.

October 24, 2014 Leap September Minor Jiawu Year.

July 23, 2017 Leap June, Year of the Great Ding You.

May 23, 2020 Leap April is the year of Gengzi.

March 22, 2023 Leap February.

July 25, 2025 Leap June.

June 23, 2028 Leap May Year of the Great Wushen.

April 22, 2031 Leap March New Year.

August 25, 2033 Leap July is the year of the Ugly Calendar.

July 23, 2036 Leap June

June 22, 2039 Leap May is the first year of the year.

March 22, 2042 Leap February.

In Excel use the if function, judge, number of days 4, integer, leap, otherwise common year.

The size of the month is more troublesome, find a master.

year = 2002;% Enter any year.

if(mod(year,4)==0 &&mod(year,100)~=0 ||mod(year,400)==0)

disp('This year is a leap year');

elsedisp('This is not a leap year');end

Determine whether the current year is a leap year or a common year.

= function ()

It's a little easier to understand.

1. First of all, enter several sets of year data in Excel**, and you need to calculate whether it is a leap year.

2. Then enter the function calculation formula in cell B1: =if((mod(a1,400)=0)+(mod(a1,4)=0)*mod(a1,100),"true","false")。

3. Click enter to see that the result in cell B1 corresponds to 2015, not a leap year.

4. Double-click the green dot in the lower right corner of cell B1 to generate the display results of leap year and common year in the figure below, true is a leap year, and false is a common year.

Conditions for leap years: the year is divisible by 4, but not by 100; But divisible by 400.

Enter the formula in any cell:

or(and(mod(year(today())4)=0,mod(year(today())100)>0),mod(year(today())400)=0)

Conditions for leap years: the year is divisible by 4, but not by 100; Or divisible by 400?

If yes, enter the formula in any cell:

or(and(mod(year(now())4)=0,mod(year(now())100)>0),mod(year(now())400)=0)

=if(mod(year(today())100)=0,if(mod(year(today())400)=0,"true","false"),if(mod(year(today())4)=0,"true","false"))

today() can also be a date-type cell reference.

Suppose column A is a year, and column B determines whether it is a leap year. The formula for cell b1 is as follows:

if(or(and(mod(a1,4)=0,mod(a1,100)<>0),mod(a1, 400)=0),"Leap years","")

First of all, let's analyze the conditions for meeting leap years: one leap in four years, no leap in one hundred years, and another leap in four hundred years. That is, every 4 years is a leap year, but when the year is a whole hundred, it must be a multiple of 400 to be a leap year; A year that is not a multiple of 400, and even a multiple of 4 is not a leap year.

The ** and annotations of the JS implementation are as follows:

function isleapyear(year) else}

But the happy experience made by the happy software found that there is a date rotator.

That's what function nyuern (y,m) is

Let's say the a1 cell is just the year 2012b1 formula,","Suppose the A1 cell is the 2012-1-23B1 formula,",4),4);Leap years"Leap years"：=if(mod(year(a1);Ordinary years","：=if(mod(a1;Ordinary years"

Let's say cell A1 is 2012-1-23

B1 formula: if(mod(year(a1),4),"Ordinary years","Leap years"Let's say the A1 cell is just year 2012

B1 formula: if(mod(a1,4),"Ordinary years","Leap years")