I'm not sure whether you want to calculate the difference between two dates,
two times or both. I'm assuming you just want to calculate the difference
between two dates (Below)

Cell A1 =Today()
Cell A2 = your target date
Cell A3 =Days360(A1,A2)
Cell A4 =Concatenate(A3," Days to go!")

If this isn't what your after I suggest doing this in VBA instead. I have
some sample code if you want it. Let me know.

Jim Nicholls




************************************************** ****

"Tim Mills" wrote:

Hi

I have 28-Jul-05 15:40:11 in cell D3 and would like to calculate the
period remaining until it is reached. I tried using NOW in another cell
and subtracting them but "VALUE" is always returned.

Is there a formula to return it in DD/MM or DD/MM/SS ?

TIA
Tim