Newbie needs help

[Ken Bessler]

I'm trying to take an amount in a cell, give a date (3 november) and todays
date,
and divide the days between now and 3 november by the amount in the cell.

Nov 3- 24 oct = 10
cell = 28
28/10 = 2.8

I've tried using the Today() and Now () function but I can't figgure it out.
If
I set cell a10 to Today() and a11 to 3-Nov then set a12=a11-a10 I get
10 Jan!

What am I doing wrong here?

Ken

kg0wx at comcast dot net

 

[Ken Bessler]

I'm trying to take an amount in a cell, give a date (3 november) and todays
date,
and divide the days between now and 3 november by the amount in the cell.

Nov 3- 24 oct = 10
cell = 28
28/10 = 2.8

I've tried using the Today() and Now () function but I can't figgure it out.
If
I set cell a10 to Today() and a11 to 3-Nov then set a12=a11-a10 I get
10 Jan!

What am I doing wrong here?

Ken

kg0wx at comcast dot net

Nevermind - I figgured it out - I had to format a12 to numbers, not date....

D'oh!

Ken

 

[Peo Sjoblom]

Format result cell as general, it will automatically format as date
and that is what you see. To quickformat as general, select an empty cell,
click the paintbrush icon, then click on A12 or just
format>cells>number>general