I can do this in Excel, just need to add it in QB.
A1 - contains date created.
A2 Calculates the ending Wednesday of the week. All dates that fall between Thursday & Wednesday will have a "Pay Date" of that ending Wednesday.
Excel Formula - =A1-WEEKDAY(A1,14)+7
thanks for any help provided!