Excel date computation

[heatherjixf]

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.

[#2]

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.

[#3]

is there a way for it to calculate a new value each day? or would I have to enter in a date each day?

[#4]

@heatherjixf

Not sure what you mean here. do you mean you want multiple dates? Could you attach an example? 

[#5]

@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?

[#6]

@heatherjixf 

Hi,

Is this what you mean?