Hi All,
I am trying to create a column that is basically, giving the variance of this week, to the previous week. I want to make this as automated as possible. An example is below: So in the table there are 5 columns with 5 dates, and I need in the 6th column to have O2-N2, and I need this to move as the weeks are passing by, so next week will show O2-P2, and so on. I want this variance to change, using the TODAY function, so when you open the file, to change.
<colgroup><col span="6"></colgroup><tbody>
</tbody>Can you help please?
I am trying to create a column that is basically, giving the variance of this week, to the previous week. I want to make this as automated as possible. An example is below: So in the table there are 5 columns with 5 dates, and I need in the 6th column to have O2-N2, and I need this to move as the weeks are passing by, so next week will show O2-P2, and so on. I want this variance to change, using the TODAY function, so when you open the file, to change.
N | O | P | Q | R | S |
11/09/2019 | 18/09/2019 | 25/09/2019 | 2/10/2019 | 9/10/2019 | VS previous WEEK |
<colgroup><col span="6"></colgroup><tbody>
</tbody>