Hi there,

This is my first post and I have a limited understanding of complicated Excel formula etc.

I have been asked to create a calendar which will display, on the applicable date of expiry, a contract name. Basically so someone can go and see what contracts are due to expire. And then if a new contract comes up it will automatically be added.

I have a list of Contract names in one column followed by the expiry date.

I have looked around and there are some things which could help but they are seriously complicated and I can't work out how to apply it to my situation.

If anyone can give me some pointers it would be greatly appreciated.

Thanks a lot.