finding number of days between dates

[gav_69]

Hi,

can someone tell me how to takes dates away from each other so i can find the number of days between for example

i want to find the how many days it is from 03-13-07 to the 08-02-07

is there a formula that i can use in excel to do this. I cant figure it out

Thanks for any help

[Richard Schollar]

Hi

Assuming these are true Excel dates eg in A1 and B1 then a simple formula like:

=B1-A1

should do it.

Hope this helps!

Richard

[Bryan Hessey]

Hi,

can someone tell me how to takes dates away from each other so i can find the number of days between for example

i want to find the how many days it is from 03-13-07 to the 08-02-07

is there a formula that i can use in excel to do this. I cant figure it out

Thanks for any help

Hi,

if the dates are in (say) A1 and A2 then =(A2-A1)+1 should work for inclusive days and progressive dates.

Chip Perason gives a full description on Dates at http://www.cpearson.com/excel/datetime.htm#AddingDates

hth
---

[gav_69]

thanks guys