Different formula than 1st row of table

[WxShady13]

I have a table that is being created by a VBA script. In the 1st row, the Payroll Date column has a formula that returns the next Thursday based on Today(). What I need after that in the following rows is the Payroll Date column to just add 7 to the starting date. Essentially it could just do a formula F5+7. How do I set that value for Row 2 and beyond and not disturb the formula in the first row?

 

[Fluff]

If you go to File, Options, Proofing, Autocorrect Options, Autoformat as you type, then uncheck "Fill formulas in tables"

 

[WxShady13]

Thank you! One add on question will that still bring in the F5+7 to the additional rows as they are added?

 

[Fluff]

Probably not, tables do not like having a mix of formulae.
I have seen situations where the formulae get badly mixed up.

 

[WxShady13]

Okay...Thank you for the advice.

 

[Fluff]

You're welcome & thanks for the feedback.

 

[WxShady13]

Just an update to this...I ended up setting a formula using an If statement where I said If the cell above = the actual Column heading then use the cell that contained the date of next Thursday, otherwise use the formula Cell Above + 7

 

[Fluff]

Glad you sorted it & thanks for the feedback.