formula

[abe]

i have a cell on my spreadsheet that i want to have a
numerical value increase daily automatically starting from
the day that it is inputed. from example in a cell if put
the value of $0.50, i want it to increase everyday by
$0.50 automatically until i put a stop on it.

 

[CLR]

IN cell A1 put your start date.......
in cell A2 put =today()
in cell A3 put =(B8-B7)*0.5, and format this cell for currency.....

Vaya con Dios,
Chuck, CABGx3

 

[abe]

i want it to automatically increase everyday without
inputing the dates everyday. then i mind as well change it
myself. i will not know when the last day is until that
day comes. point is to automatically increase every day
without doing anything to it

 

[CLR]

Two problems.........first, somehow I did a typeo and gave you the wrong
formula for cell A3.......it should have been =(A2-A1)*.5 instead of
=(B8-B7)*.5........sorry about that......

Second, I apparently didn't make it clear that you only have to do this
typing in these three cells once.......the formula =today() will
automatically display the date of whatever day it is that you open the
workbook........and the formula =(A2-A1)*.5 will automatically
calculate back to the start date and give you your value of 50 cents per
day......and don't forget to format cell A3 as currency.

Vaya con Dios,
Chuck, CABGx3