automatically add a numerical unit on a daily basis begining with a date specifi

A

abe

i would like to know the formula you use to have a
numerical value(currency) in a cell automatically increase
daily starting from a specified date in another cell.

thank you
 
G

GB

abe said:
i would like to know the formula you use to have a
numerical value(currency) in a cell automatically increase
daily starting from a specified date in another cell.

thank you
Click to expand...

Could you explain that a bit more, please.
 
A

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 until i put a stop on it
 
G

GB

Try = 0.5*(Today()-Date(2003,9,20))

abe said:
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 until i put a stop on it
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

MS Project. Real progress of the project, % complete 1
Newbie Help - IF Yes No Function 0
Would like to input 3 letters into a cell, each having a different numerical value 5
Linking data in MS Word into Excel 5
Using <= in countifs statement 1
Testing a cell value for a specific weekday. 4
Excel does not accept text format! 0
match dates in two columns get value from third 1

Top