Autopopulate table

[BRISBANEBOB]

How can I autopopulate a calander with a syllabus depending on starting date? I attached a sample spreadsheet.

Thanks for any ideas.

[Richard Buttrey]

Hi,

Create an offset cell say A13 which will determine where the week starts with the formula

Please Login or Register  to view this content.

Now in B16 enter

Please Login or Register  to view this content.

and copy this across and down to B16:BA19

HTH

[BRISBANEBOB]

Beautiful - thank you very much.

[Richard Buttrey]

Beautiful - thank you very much.

It's a pleasure. I forgot to suggest using conditional formats to set the font to white when the cells evaluate to zero

Rgds

[BRISBANEBOB]

I've got Excel set not to show zeros. Thanks for post script.