Looking to auto-populate dates

dtoldy 

A question or two and a request

Q1 what is the pay frequency here (weekly, monthly, semi-monthly, bi-weekly? something else?)

Q2 can you explain the relationship between the entries in the three columns in your image (more specifically "How are we to make sense of the fact that  'Paydate' fall outside of the boundaries of 'Pay period start' and 'Pay period end'? and what bearing does that have on the deductions for rent?)

Request: can you post a copy of the actual spreadsheet involved here, after changing any real names to the names of Disney or Star Wars characters? It would be a lot easier to work with real (but anonymous) data, than with an image of said data. Post that spreadsheet on OneDrive or GoogleDrive with a link pasted here that grants access.