Jan 01 could start on any day of the week - your weeks are just 7 day
increments starting from Jan 01 without regard to the day of the week?

--
Regards,
Tom Ogilvy

"Danny" wrote in message
...
I am creating a work management schedule for my staff and
i want it to be really easy to use and menu driven. I have
each week of their work as a separate worksheet numbered
WK1 - WK52 for the year. I want to know what the code
would be which would automatically select the relevant
worksheet depending on the date, i.e if it is the 1st of
January the macro opens WK1 and if it is the 30th of
December the macro opens WK52.

I.e.

if today = 01 Jan, 02 Jan, 03 Jan, 04 Jan, 05 Jan, 06 Jan,
or 07 Jan open 'WK1!'A1

etc.

Anyone know how i may do this?