patterns in Excel

Hi.

I am doing more work on shift patterns and have been past a shift that no one knows the actual break down of the pattern and its a 20 week pattern. Obviously I can just look through it and work it out, but as I am doing a lot of these I was just thinking.....

Is there a way Excel can tell me what the pattern is?

An example spreadsheet would help...