Countdown by days

rgoode · Apr 2nd, 2002, 08:47 AM

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 · Apr 2nd, 2002, 09:09 AM

Quote:

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 · Apr 2nd, 2002, 09:11 AM

Thanks, I was trying to make it too difficult.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 2nd, 2002, 08:47 AM	#1
rgoode New Member Join Date: Apr 2002 Posts: 6	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.

Apr 2nd, 2002, 09:11 AM	#3
rgoode New Member Join Date: Apr 2002 Posts: 6	Thanks, I was trying to make it too difficult.