My paychecks are every other Friday. I want to auto-populate for a given pay period what bills to pay. Here's the pseudo code:

if [cell:pay date] > 15 and [cell:bill due date] is < 15, then insert [cell: bill name] into [cell: pay period bill name] and [cell: bill amt] into [cell: pay period bill amt]
if [cell:pay date] < 15 and [cell:bill due date] is > 15, then insert [cell: bill name] into [cell: pay period bill name] and [cell: bill amt] into [cell: pay period bill amt]

Thank you!