I would like to know how to have one cell contain the Today() function and another cell contain a "date" in the future, where yet another cell will calculate how many days left until the future date.

I am getting results like 08/09/1900. All I want is a number

Thanks