Increase Cell Value Daily

Crewman

New member
Joined
May 17, 2013
Messages
1
Reaction score
0
Points
0
Location
Australia
I am seeking a formula that will increase a cell value by a specific value (ie. 0.92) each day, with the cell value being up-to-date for whichever day in the future I might open the file. The formula would need to start its calculations from a specific number (ie. 345.28), which will be current on the date of creating the file.

Weekdays versus weekends has no bearing as the specific value is to be progressively added for every day.

Many thanks in advance.
 

royUK

New member
Joined
Mar 22, 2011
Messages
155
Reaction score
0
Points
0
Location
Derbyshire, UK
Website
www.excel-it.com
Excel Version(s)
most versions
I doubt that you would be able to do this with one cell.

I would suggest in B1 enter the start date, in B2 enter the start value then in B3 enter this formula

=(TODAY()-B1)*0.92+B2
 
Top