Formula Help re: Recurring dates

Hi There,

Hoping someone can help. I'll give you what I am trying to do first and what i have tried in excel.

I do a running sheet budget, and day of the year is listed down the left e.g. Tues 17th May, Wed 18th May etc. I then separate these using borders into each pay week, and list what bills are due that week and what income is in that week, giving a balance remaining.

Lets say that Bill A comes in on the 1st of every month, and Bill B on the 10th of every month. I want to make sure that every time the 1st is listed, it looks up the bill due on that day and displays it...

what i tried was putting a single digit number in the column next to the date to represent the day...e.g. 1, 2, 3, 4. I then tried an IF statment saying IF this cell was this number, then display Bill 1. I couldnt figure out how to do it for all bills and all cells in that column..

any ideas?

thanks!!