Hi,

Im trying to get the difference in days between 2 dates ignoring the leap years.

I have searched google and checked lots of formulas. The closest I have got is this -

= B1 - DATE(YEAR(B1), MONTH(A1), DAY(A1)) + 365 * (YEAR(B1) - YEAR(A1)) - SIGN(B1 - A1) * (DATE(YEAR(B1), 3, 1) - DATE(YEAR(B1), 2, 29))

However on closer checking. Its returning a total of 364 days where i use the 2 dates 19/01/2007 (A1) and 19/01/2008 (B1). I would be expecting a total of 365 days.

Can anyone help me out on this??