Formula for Calendar with reoccuring events

I am new to forum. I have a calendar in excel that has each month on its on sheet with excel spreadsheet. I will attach it here.

What I need a formula that will automatically input data in the field under the day of each month.

Such as the 1st and 15th of each month is payday. I want to be able to input this data so that each year as the days change, payday will show on 1st and 15th.

This is, of course, one example. I'd like to include holidays, birthdays, monthly bills/appointments, etc., that continuously generate on the correct date as the years go by.

I am a beginner at excel too, so I need as much detail/explanation as possible.

I appreciate it in advance!

See if the attached works for you.

Hope this helps.

-Z

[/LIST]Thank you so much Z!!!! That was exactly what I was needing. Since you're so good at formulas, I wonder if you could help me with a few more.

I need a reoccurring calendar formula for the following examples please:
•I need a formula that can set appointments for a specific day of the week, like every Wednesday is church.
•I need a formula that can set appointments for a specific day of the month, like every month that has a 5th Sunday is Dinner on the Grounds.
•I need a formula that knows if payday (which is the 1st or 15th of the month) falls on a Saturday or Sunday, that’s it’d be automatically moved to the business day prior to the 1st or 15th.
•I need a formula that can set holidays if they fall on a specific day of the month, like Thanksgiving.

and if you could put in the excel document like you did last time, I would really appreciate it! Thank YOU again!!!

Zodeeak,
I appreciate all your help! I have noticed one thing though.

If you look on Jan tab to the right is a scroll bar that changes the year and the dates correspond with it. While you were editing the excel sheet, the year on each month doesn't change now. the dates still do, but the year displayed with the month always says 2014. Could you fix this for me please, if it's not any trouble? Thanks!!!!

You're awesome! thanks!!!

Is there a way to make this calendar list multiple event on one day? I am trying to create a Finance Task Calendar where 3-4 items may be due on the first work day of the month, 2 items due on the 2nd, etc... So far, on this version i can only list 2 task on any particular day and it stops showing the tasks.

Thanks in advance! :-)