Forum Discussion
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.
if you place a date in cell a1, =TODAY()-(A1) will give you a count from that date until today. You must format the formula with number or general format, not date format.
- is there a way for it to calculate a new value each day? or would I have to enter in a date each day?
Not sure what you mean here. do you mean you want multiple dates? Could you attach an example?
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?
