Calculating Dwell time

Susanna Ferry

I am trying to get the dwell tome to show in my sheet by using the formula below, but it wont bring back a value for me in days only showing '0', I have applied the formula to the whole column 'Dwell time' what could I be doing wrong please ?

Nic Larsen

Have you tried switching your formula so it's the Date Course - Today's Date? I suspect you are getting a negative number and its rounding to zero.

In a simple test on my sheet, if I go the other direction, I can get a decimal or whole number depending on the results you're looking for.