Date Differences and ignoring Leap Years

1. Date Differences and ignoring Leap Years

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??

2. Re: Date Differences and ignoring Leap Years

To count all days except leap days

=SUMPRODUCT((TEXT(ROW(INDIRECT(A1&":"&B1)),"ddmmm")<>"29Feb")+0)-1

3. Re: Date Differences and ignoring Leap Years

that seems to it...thanks a million!!

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1