Is there a quick and easy way to calculate how many days total

[lokiju]

I need to calculate exactly how many days it was for specific ranges and since this might be a common thing I'll need to easily find out, I'd like to know whats the fastest way to do it?

for example, I have these ranges of dates and for each one I'd like to know how many days total each one was.

10/9/2003 to 5/25/2007
7/20/2005 to 5/15/2007
7/20/2005 to 5/15/2007

 

[FoBoT]

http://www.timeanddate.com/date/duration.html

 

[ric1287]

haha, i made thread on this exact topic a few months ago. I ended up writing some forumal's in excel that did it for me.

 

[lokiju]

Originally posted by: FoBoT
http://www.timeanddate.com/date/duration.html

OMG!

That's exactly what I needed.

:beer:

 

[Chronoshock]

I think inevitably any code you write has the horrible kludge of leap year code in it (year%4 == 0 && (year%100!=0 || year%400==0))