Calculating number of days between two dates

Hello,

I'm trying to determine the number of days taken to assess a claim, in Column E I have the date received and Column F the date determined. If the claim was received and assessed on the same day than that would count as one day.

claim_received_date claim_detrmd_assd_dte Days
2008-11-05 00:00:00.000 2008-11-05 12:00:17.000 2
2008-11-10 00:00:00.000 2008-11-10 11:58:02.000 1

PHP Code: 

=F2-E2+1 


I'm using the above formula, but Excel rounds numbers up and instead of the two records above being 1 day, the first counts as 2 and the second as 1. I'm trying to use whole numbers as opposed to any decimal points.

Hope this makes sense.

Thanks in advance.

Hi

Try:

=INT(F2)-INT(E2)+1

Richard