Date difference

[duugg]

Is there a formula or something simple that I can do in Excel that allows me to compare the dates in a1 and b1 and tell me how many days difference it is and put the result in c1?

Thanks in advance.

[duugg]

Never mind, I figured it out. Didn't realize it was that simple.

[oldchippy]

Is there a formula or something simple that I can do in Excel that allows me to compare the dates in a1 and b1 and tell me how many days difference it is and put the result in c1?

Thanks in advance.

Hi duugg,

Start date in A1, end date in B1, then in C1

=B1-A1+1

oldchippy