Help with Formula to give the diference of days between 2 dates

Stumped... Trying to get the results in days between two dates.
Cell T and Cell U are dates that are entered in to the sheet. $C$1 is the current date of the day.

If both T=0 and U=0, then the cell should be blank. It T has a date and U=0, then it should give the number of days between T and $C$1.

If both T and U have a date, then it could be blank or, preferably, it could have the difference in days between the dates in T and U.

So far I have something like this... which isnt working or sorting well...

Formula:

Please Login or Register  to view this content.

If someone would like to take a look at the sheet I would be happy to share it... thanks

this is what I come up with, substitute T and U appropriately
=IF(AND(T2<>"",U2<>""),DATEDIF(T2,U2,"d"),IF(AND(U2<>"",T2=""),DATEDIF(T2,A2,"d"),IF(AND(U2="",T2=""),"")))
where T is your one earlier date and U is your later date and A is your TODAY().

Hi,

Can you post a sample workbook if Sambo's formula doesn't work ?