Excel assistance required

[Pixie]

Hi, I have an Excel spreadsheet with 15 different worksheets.

Each worksheet relates to a set day on a programme of 15 days. Is there a way of inputting the first date on the first worksheet and having the rest of the sheets popluated with the correct date for that sheet?

i.e if i type in Monday 15th June on the first spreadsheet, is there a way of getting Tuesday 16th June to come up on the 2nd spreadhseet etc?

Thanks

 

[Kafrin]

Hi Pixie,

I can answer your question, but you might have more luck in future if you post on the correct board; there is an Excel board on these forums.

So to answer, yes you can do what you're asking. Choose the cell on the first sheet where you are going to enter the date. For my example, this is cell B2. On the second sheet, go on to the date cell and type:
=1+'Sheet1'!B2
This will add one day onto the date. Repeat for the other sheets, changing the 1 to a 2, 3, 4, etc.