Is there a site that calculates the number of days between 2 dates?

[Marcos]

Or am i being thick and theres a simple way to work this out that i don't know yet?

[chicken]

Open Excel, type a date in cell A1, type another in cell A2, then in a third do "=A1-A2" if you have any problems make sure they are all set to "date" format. I'm pretty sure that will let you know... it's possible also to filter the results a bit more but you can google for that

[LWA]

If you have an Oracle database handy:

select to_number(to_char(to_date('01-JAN-2007','DD-MON-YYYY'),'J'))-to_number(to_char(to_date('01-JAN-2006','DD-MON-YYYY'),'J'))
from dual

That code gives the number of days between 1st Jan 2006 and 1st Jan 2007.

Perhaps that's overkill

[Parm]

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

There is always a website.

[fuddam]

if using excel, you need the calc cell to be formatted NOT to date, but to GENERAL or one of the other number formats


also, first cell must be the more recent date, otherwise get garbage. ie new date minus old date

[Marcos]

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

There is always a website.

perfect!

[scottyman]

fuddam - there are date specific calc functions built into excel also, but you can cast the date to a numerical value.
timeanddate.com is an excellent resource - their clock applets make life much easier!

[Stoo]

or you could just add up the days between the two dates

[LWA]

or you could just add up the days between the two dates

Oh my god, what a crazy notion!