Leap Year in Excel - Count how many leap years between dates
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...