Bi-weekly pay period

I'm trying to calculate the last bi-weekly pay day in any given month, for example this month my pay dates are as follows; 1 Jul 2016, 15 Jul 2016, and 29 Jul 2016. I want to automatically show the last payday of this month regardless on what day today is. I've been playing with this formula, but when I roll over to the next month it doesn't follow correctly

=IF(MONTH(N3+28)-1=MONTH(DATE(2016,1,1)),EOMONTH(N3,0),N3+28)
Where as "N3" is always the 1st day of the current month, this works fine until I change "N3" to any day in August, then it returns 29 Aug 2016 when it should show 26 Aug 2016 to continue the bi-weekly pay schedule

Originally Posted by Phuocam

...

=CEILING(N3,28)+20

Sweet, yes that works!! Thank you! I actually did come up with another formula "=LOOKUP(N3+31-DAY(N3+31),N3+MOD(DATE(2016,1,1)-N3,14)+{14,28})" But yours is SOOO much simpler!!