Countdown by days

[rgoode]

I have a spreadsheet where I would like to know how many days there are from the current date until specified dates. I am using the Today() function to obtain the current date and I have entered some dates that I would like to countdown to in column B. I know how to obtain the amount of time left in years, months, and days, but I would like to just have the amount of time in days. Thanks.

 

[Russell Hauf]

On 2002-04-02 07:47, rgoode wrote:
I have a spreadsheet where I would like to know how many days there are from the current date until specified dates. I am using the Today() function to obtain the current date and I have entered some dates that I would like to countdown to in column B. I know how to obtain the amount of time left in years, months, and days, but I would like to just have the amount of time in days. Thanks.

Just subtract one from the other, and format the cell as a number.

Hope this helps,

Russell

 

[rgoode]

Thanks, I was trying to make it too difficult.