Excel date computation

Copper Contributor

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.

5 Replies
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?

@heatherjixf

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?

@heatherjixf 

 

Hi,

 

Is this what you mean?

 

excel.PNG