FIFO roster calendar identifying same days off

[Spicey_888]

Hi all,

Long story short, I got sick of a crappy app that wasn't working for me and my mates and I thought it would be cool to make an interactive calendar in excel. As I have done nothing of the sort before I wanted to get some ideas and possible suggestions on how to make this work.

Ultimately I would like to have 3 sheets. One were I can enter the names and corresponding reoccurring roster, that would be days on days off, a second sheet that does all the calcs etc and returns days of which all or most of the people are going to have off at the same time, so we can organise things in advance and maybe a third sheet that shows an actual graphical display of this information like a traditional calendar.

Firstly is something like this possible (I'm pretty sure it is), can it be done without macros or should it be done with macros etc. if u have ideas or even better, solutions to post that would be awesome. I'll also post a copy of the final product on here for anyone else who might find it handy.

I hope this sought of thing is within forum rules and I've posted in the correct forum. I'm going to sleep on some ideas but I plan to tackle it head first in about 9 hrs. All help is greatly appreciated!

Regards,
Ben

[Pete_UK]

Take a look at this thread:

http://www.excelforum.com/excel-new-...o-a-sheet.html

which has links to several solutions of mine involved in generating a calendar, so perhaps you can amend one of those, or post back if you need any further help.

Pete

[Spicey_888]

Cheers Pete,

Some of the threads look pretty helpful.

I will still leave this open for any ideas or codes that people may suggest.

Ben