[vikki]

does anybody know if there is a away to do a formula to calculate days between 2 dates?

EG' the amount of days between august 2006 - september 2008.

any help would be really apprciated.

[xircon]

Example:
Put date1 in A1 put date2 in B1 in C1 type =a1-b1

Then reformat cell to general or number. (press ctrl+1)

[ASPGuru]

Lots of good Excel date stuff here - http://www.nwarwick.co.uk/ExcelDateHandling.html

To do what you have asked:

To calculate the number of days between two dates use the formula:
=DATEDIF(A1,TODAY(),”d”)

Or to use Xircon's example...
=DATEDIF(A1,B1,"d")

[Tricky]

Interestingly (or maybe not) there is a fault on some versions of Excel to do with leap years and subtracting dates. But if all the dates are in 2008, it shouldn't be relevant anyway.

[vikki]

most of the dates go as far back as 2002.

thanks for the response they have worked but i am now concerend about the leap years.

[floyd77]

Use Julian dates

http://www.cpearson.com/excel/jdates.htm

[Tricky]

Or setting your excel sheet to use base 1904 should do the trick.

tools ---> Options----> Calculation. Check bottom left box.