Hi,

In a 401(k) plan, employees enter the plan on the first date of the next payroll period after they've been employed for 120 days. I can calculate 120 days after their date of hire. But I am wondering if anyone knows a formula that will return the first date of the next bi-weekly "Sunday to Saturday" payroll period after any date. For example:

Let's say the employer's first 2016 bi-weekly payroll period runs from Sunday 1/3/2016 to Monday 1/16/2016, the second runs from 1/17/2016 to 1/30/2016, and so on. An employee has been working 120 days for the employer on 8/10/2016. Does anyone have a formula that will return the first date of the next bi-weekly pay period after 8/10/2016 (8/14/2016)?

Thanks in advance of your response!