On Feb 9, 9:33 pm, "Roger Govier"
wrote:
Hi

Example in Australia March 1st starts on Thursday

Surprisingly, it does here in the Uk as well <vbg

On your first weekly sheet enter in A1
01/03/2007
in A2 enter
=IF(A1="","",IF(WEEKDAY(A1)=1,"",A1+1))

Do the same for your other weekly sheets, except in cell A1 of Week2
enter
=MAX(Week1!A:A)+1

On the other sheets of course it would have to be looking at Week2,
Week3 and Week4

--
Regards

Roger Govier

"pano" wrote in message

oups.com...



Hi all,

I have a workbook with 31 sheets for each day of the month, I also
have 5 sheets for weekly data.

How do I for every month put a date on a menu sheet so that the start
of the month (day) date is put into the right sheet and have the
weekly data sheets match up.?

Example in Australia March 1st starts on Thursday and I need Friday
Saturday Sunday to appear on the 1st weekly sheet.. and so on.

thanks for any ideas..
Stephen- Hide quoted text -

- Show quoted text -

Thanks to both of you. They work very well and today is Friday 10.48pm
Bigger (VBG)