Leap year in Excel is a formula that you need to know. Whether you want to check if a date is in a leap year, or you want to know how many leap years are between two dates working out the leap year in Excel is a must have formula.
This Excel tutorial on how to create leap year formulas in Excel will show you how to do a basic formula all the way to how to calculate leap years between two dates even if they are hundreds of years apart. This is especially important considering that if a year the start of a new century and is not divisible by 400, it's not a leap year.

00:00 - Start.
00:40 - Check if year is a leap year.
03:07 - Count number of leap years between 2 dates.
08:17 - How to account for end of century years?

Written instructions with updated functions and formulas can be found at:
📃https://www.computertutoring.co.uk/ex...

📷  / thecomptutor  
📸  / ct_training  
🤳  / computer_tutoring  
🔗  / computer-tutoring  
🐤  / ct_tutoring  
😉https://www.facebook.com/pages/Comput...