Pay Period start date

[CSP4513]

Hello, I need a formula for auto updating pay period start date. Example, when pay period column is manually increased from 1 to 2, payroll start date column
automatically advances 14 days
Thanks

 

[Legacy 143009]

Like this?

 

[Pentarch]

Like this?
View attachment 96153 View attachment 96154

That's such a straight forward way of doing it.
I was thinking of a helper sheet with pay periods vs pay start/end dates and doing a vlookup, but yeah, this is much simpler.
I tend to over complicate things for myself.

 

[Legacy 143009]

Yes, somethimes I do the same