I want to autopopulate bill info for a given pay period, based on due date

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!

Try

in cell "Period Bill Name"

=IF(AND(DAY(cell:pay date)>15,day(cell:bill due date)<15),cell:Bill name ,IF(AND(DAY(cell:pay date])<15,day(cell:bill due date)>15),Cell:Bill Name),"")

in cell "Pay Bill Period Amount"

=IF(AND(DAY(cell:pay date)>15,day(cell:bill due date)<15),cell:Bill Amt ,IF(AND(DAY(cell:pay date])<15,day(cell:bill due date)>15),Cell;Bill Amt),""),"")

Reverse > and < for second condition

What about "equal" condtions

so ">=" and "<="

The double quotes at the end gave me a "too many arguments" error so I backed off of them and it worked! Exactly what I was looking for and could never have figured out on my own. Thank you!!

Kudos for recognizing I needed to consider = 15 as well.

-Mary

Sorry about the double quotes: I didn't intend you use them .. merely to highlight the required change!

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.