How to use excel to determine whether it is a leap year

How to use excel to determine whether it is a leap year:

1. First, enter several sets of year data in the excel table 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 ).

3. Click Enter to see that the result in cell B1 corresponds to 2019, which is an average year.

4. If you need to generate leap year display results in batches, you can double-click the green dot in the lower right corner of cell B1 to generate the leap year and ordinary year display results in the figure below.

Recommended learning: Excel basic tutorial

The above is the detailed content of How to use excel to determine whether it is a leap year. For more information, please follow other related articles on the PHP Chinese website!