This formula will show the difference (in days) between two dates.

In C2 enter:

=IF(B2A2,INT(B2)-INT(A2),"")

For example if your due date is in A2:A118 and the actual delivery
date is B2:B118, simply fill this formula down all the way to C118.


HTH,
JP

On Jan 28, 12:04*pm, "Kelly_Durden" <u41001@uwe wrote:
Hello,

I have a 118 expected deliveries, the due dates are in column B2:B118. I want
to try to calculate the number of days the delivery are overdue by?

Can someone please help me with a formula for this?

Thanks
Kelly