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.
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?
Not sure what you mean here. do you mean you want multiple dates? Could you attach an example?
