=B1-A1 and format as General, not as Date, which Excel does automatically.

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Qazi Ahmad" wrote in message ...
| My one cell have today date with formula =Today() and i want total remaining
| day in Numbers from any given future date. Exp. I put in one cell 30/5/2007
| other cell have 31/12/2007 and the result should be show in numbers how many
| remaining day from today to till last day of give future date.
| Thank you