Hello, somewhat new to airtable and using the Payroll Timesheet Template available in the template library. However, I’m having a bit of trouble figuring out how to properly calculate the pay periods as they’re not every 15 days (like in the template), but rather the 15th and the last day of the month. It currently takes the
Start Date formula DATEADD({Start of Pay Period 1},({Pay Period Number}*14)-14,'days')
and the
End Date formula* DATEADD({Start Date},13,'days')
to calculate the
Pay Date DATEADD({Start Date},13,'days')
I am wondering how best to calculate the Start and End Dates based on the Pay Dates always being the 15 and the EOM (30th or 31st). I’ve been playing with different formulas all day and have figure out how to calculate EOM at least, but not how to specify the 15th and EOM as the pay dates and at this point it’s all starting to look like hieroglyphics to me.
If anyone has come across a solution or similar use case and could shed some light on this, I would be deeply grateful.