DIGIT-ARC read-only archive · snapshot: July 23, 2026

DIGIT-ARC / Software / Software Q&A

Calculate no. of leap years between 2 dates in MS Excel

2 posts · originally from https://geek.digit.in/community/threads/calculate-no-of-leap-years-between-2-dates-in-ms-excel.119276/

abhijit_reddevil
abhijit_reddevil Original post #1
Jul 13, 2009 at 11:27 AM
Hi,

How can I calculate the no. of leap years between 2 dates, say 11-May-1980 and 12-Dec-2007, using MS Excel? Which functions and/or formulas should I use?

Thanks.