difference between dates

Originally Posted by daddylonglegs

Do you have formulas in E10 and Q10?

Sorry I didn't say.

Yes, they are to formulas, the two dates are pulled thru from two different spreadsheets.


I have just used Ed's formula and it cleared up the problem, brilliantly.

Many thanks everyone.
Your help was invaluble, as always.