Calendar with updating recurring events

[Jessmack]

Hi Guys,

I have searched the internet, but can't seem to find a way to do what I need.

What I am looking at creating is a document with a calendar on one tab and a data sheet on another.

The data sheet would be something like:

Company | $$ | Recurring? | How often? | Start Date |
Optus |$100| Y | Last day of every month| 10/10/14
Electricity| $200| Y | Every 3 months | 11/10/14
Gym | $15 | Y | Every 7 days | 9/10/14
Bike |$300| N | | 20/10/14


ETC.

And what I want to achieve is the calendar updating automatically.

Any help would be appreciated. Trying to set up something for my dad to get all of his affairs in order.

Cheers!!

 

[ztodd]

Have you checked out google calendar? Or do you have outlook? What programs have you looked at so far?

Finding something already built would be a lot better solution for this type of thing.