Tony,

If you put the year number in say B2 as well as the week in B3, this works
for all years

=TEXT(DATE(B2,1,1)-WEEKDAY(DATE(B2,1,1))+2+(7*B3),"dddd dd-mm-yy") & " to "
&TEXT(DATE(B2,1,1)-WEEKDAY(DATE(B2,1,1))+2+(7*B3)+6,"dddd dd-mm-yy")

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Tony Ramsden" wrote in message
...
Ron

I want to use the same system that my palm uses, the idea behind the
spreansheet is to contain oncall info for work , I shall mainly be
using my Palm Tunsten C at work, but with access to my home PC aswell
as work PC's. I can simply reach for the Palm to tell colleagues when
their Oncall is.
The Palm's Week 1 for this year is Mon 30 dec 2002 to Sunday 5 Jan
2003.

Bob Phillips method works great for this year. One question about his
method is how do I work out the dates for say week 5 2004...


Thanks for all replies

Tony


On Fri, 10 Oct 2003 22:18:24 -0400, Ron Rosenfeld
wrote:

On Fri, 10 Oct 2003 22:29:08 +0100, Tony Ramsden
wrote:

How do I make my excel sheet indicate the actual start and finish
dates of a working week when the week number is inserted,( It would
also be nice to do the opposite and give a date and have the week
number shown but not imperative).. So

if I input the week number in B3
and hey presto..
The week dates shown in say C3 (& C4-C7 if necessary ), in the format
of
Monday dd-mm-yy To Sunday dd-mm-yy

Many thanks

Tony

Tony,

Your question lacks information as to how you define Week Number.

There are a variety of definitions available. For example, the ISO
definition
states that a week always begins on a Monday, and Week 1 always contains
the
first Thursday of the year (or January 4th). So the first week might
have as
few as four days, and the first day or two of one year might really fall
in the
last week of the preceding year.

You could define Week 1 as always starting on Jan 1, without regard to
the day
of the week.

Or you could use the definitions implied by the Excel ATP WEEKNUM
function.

So to accurately answer your question, you need to define your week
number.




--ron