Solved

# how to check if a year in a cell is leap year

Posted on 2014-10-29
99 Views
i have a column of years that i want to check which one of them are leap year. how do i do that?
0
Question by:Flora
[X]
###### Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

• Help others & share knowledge
• Earn cash & points

LVL 26

Accepted Solution

ProfessorJimJam earned 500 total points
ID: 40412324
=((MOD(A1,4)=0)*((MOD(A1,100)<>0)+(MOD(A1,400)=0))=1)
0

LVL 6

Author Closing Comment

ID: 40412325
thanks.
0

## Featured Post

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This code takes an Excel list of URL’s and adds a header titled “URL List”. It then searches through all URL’s in column “A”, looking for duplicates. When a duplicate is found, it is moved to the top of the list. The duplicate URL’s are then highlig…
Excel can be a tricky bit of software to get your head around. Whilst you’ll be able to eventually get to grips with the basic understanding of how to get by, there are a few Excel tips that not everybody will even know about let alone know how to d…
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.
###### Suggested Courses
Course of the Month8 days, 22 hours left to enroll