Forum Discussion
heatherjixf
Aug 11, 2020Copper Contributor
Excel date computation
Hello, is there a way to compute a rolling date in an excel cell? Given a start date I want to calculate a daily value in a cell, that updates with each new day.
heatherjixf
Aug 11, 2020Copper Contributor
is there a way for it to calculate a new value each day? or would I have to enter in a date each day?
Poogermum
Aug 11, 2020Brass Contributor
Not sure what you mean here. do you mean you want multiple dates? Could you attach an example?
- heatherjixfAug 11, 2020Copper Contributor
Poogermum I want to compute a daily amount that updates with each new day. For example, from June 15, 2019 to today, at $1,000 each day. Then update daily. Is that possible?
- PoogermumAug 11, 2020Brass Contributor