Gilham Consulting wrote:
I have rather large change to the formula based on our pay period.

When the A1 date equalling the 27th to the 11th it return 15th of that month
(2/27 to 3/11=3/15) and the 12th to the 26th return the 30th of that month
(3/12 to 3/26 = 3/30).

Thanks again for your help on this stick situation!





=IF(OR(DAY(A1)26,DAY(A1)<12),DATE(YEAR(A1),MONTH( A1+5),15),
DATE(YEAR(A1),MONTH(A1),MIN(30,DAY(DATE(YEAR(A1),M ONTH(A1)+1,0)))))