Newbie needs help

  • Thread starter Thread starter Ken Bessler
  • Start date Start date
K

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 said:
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
Click to expand...

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

D'oh!

Ken
 
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
 
Back
Top