Hello, am trying to think of a way that if I have a date entered in one column, if there's a formula that can reference that date, and populate a date in another column that reflects the date of the start of the following pay period? For example:

A1 = 02/10/15
A2 = 02/23/15 (the start of a new pay period).

The pay periods are bi-weekly - so every other Monday new employees come on board. I'm trying to figure out if there's a way bo build in an established sequence no matter what date gets put in A1.

Thanks! Chris