Bi-weekly pay period

Originally Posted by Phuocam

Try this ...

=MIN(EOMONTH(N3,0),EOMONTH(N3,-1)+29)

It's still shows 29 August instead of 26 August like it should, this works fine as long as it's still July but doesn't quite reciprocate into the next month and so on.