Forum Discussion
Looking to auto-populate dates
Hi there,
I am trying to create a tracker for individuals living in company housing and paying rent. I have dates in columns such as Move In Date, Move Out Date, # of Days in Housing. What I'm trying to do is use our payroll calendar on another sheet to calculate how many paychecks fall into the period from Move in to Move Out and divide their rent evenly across those paychecks. Now - We do not start deduction until paycheck #2 and do not collect from the last paycheck, so I need it to calculate the second pay date and second to last.
Is there a formula I can put into Colum J, K, L and M to auto-calculate this? I'm assuming an If function?
This is sheet 2
Thanks!
D
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.
