Hi
I have a table where the headers are weeks.
I want the user to update the first column header and the subsequent headers would update by each week.
e.g. Column A is 10-Jun and formula in column b onwards is A1+7 etc
<tbody>
</tbody>
If I drag the formula in a table it doesn't work unless it's in a table?
any way round this?
Many thanks
I have a table where the headers are weeks.
I want the user to update the first column header and the subsequent headers would update by each week.
e.g. Column A is 10-Jun and formula in column b onwards is A1+7 etc
10-Jun | 17-Jun | 24-Jun | 01-Jul | 08-Jul | 15-Jul |
<tbody>
</tbody>
If I drag the formula in a table it doesn't work unless it's in a table?
any way round this?
Many thanks