Days360 Function

**AdamParker** · 11-26-2009, 04:26 PM

Hey guys..
I was calculating the number of days between two dates using the Days360 function. However, now it is not accurate enough for me... Is there a function that is more accurate? based on 365 days and includes leap years... that I could use as I need this calculation to be exact?

For example, number of days between April 1st, 2010 and August 31, 2012 is 884, but the days360 function returns 870.

Any advise would be greatly appreciated, VBA is not out of the picture.

Thanks,
Adam

**darkyam** · 11-26-2009, 04:29 PM

=A2-A1+1 should work.
That takes the difference in days inclusive of both start and end dates.

**rwgrietveld** · 11-26-2009, 04:51 PM

See DATEDIF a http://www.cpearson.com/excel/datedif.aspx

... and I think the result is 883

**AdamParker** · 11-26-2009, 05:20 PM

Thank you both very much! -Adam

**darkyam** · 11-26-2009, 05:24 PM

rwgrietveld, it depends on how you count. If you subtract today from tomorrow, you get 1 in Excel, but you could also count it as 2 days if you're being inclusive of both start and end dates.