+ 3 each day

[NewExcelUser]

Good Day,

I am working on a project which requires a numerical value in a cell to be + 3 with each day that the file is open. For example

Day 1: Cell a1 = $50.00

When the file is opened on day 2, cell A1 would automatically update:

Day 2: Cell a1 = $53.00

And so on and so forth.

How can this be done?

TIA

[mrice]

You could use a formula like

= 50 + (3*(NOW()-DATE(2006,1,1)))

where 50 is the start value and the figures in the date portion represent the day which is time zero (in this case 1st Jan 2006)

[NewExcelUser]

Hello

Thank you for your response! However, the + 3 would coincide with a date change and would be + 3 of whatever the previous dates value in that cell was. For example..

11/12/06

Cell a1 = 50

11/13/06

cell a1 = 53

11/14/06 = 56

But the addition would take place once the date was automatically changed (upon file open) and would be + 3 of the previous days + 3....

I hope this explains some....

Any help provided would be much appreciated!