Hi,
I have a column with a week number (15 for example) and i would like to
return this number in the format of date. Better: it has to be the Friday of
this week number.
Example : Week Date
15 07/04/2006

Hope that somenone can help me.
Tkanks,
Barbara

Hi Barbara:

In A1 put the week number
in A2 put:
=38718+7*A1-9 and format as a date.
--
Gary's Student


"Barbara" wrote:

Hi,
I have a column with a week number (15 for example) and i would like to
return this number in the format of date. Better: it has to be the Friday of
this week number.
Example : Week Date
15 07/04/2006

Hope that somenone can help me.
Tkanks,
Barbara

The only way I know would be to make seperate table with a list of the
week numbers and the dates for each week and then use a lookup to check
for the value to be entered in your main table.

But I dont know much about Excel and there is proberbly a better way so
I would wait for one of the others to see what they say.


--
johneva
------------------------------------------------------------------------
johneva's Profile: http://www.excelforum.com/member.php...o&userid=34156
View this thread: http://www.excelforum.com/showthread...hreadid=539216

try this.
=DATE(2006,1,1)-WEEKDAY(DATE(2006,1,2))+B1*7

--
Don Guillett
SalesAid Software

"Barbara" wrote in message
...
Hi,
I have a column with a week number (15 for example) and i would like to
return this number in the format of date. Better: it has to be the Friday
of
this week number.
Example : Week Date
15 07/04/2006

Hope that somenone can help me.
Tkanks,
Barbara

Thanks Gary
It works!!!

"Gary''s Student" escreveu:

Hi Barbara:

In A1 put the week number
in A2 put:
=38718+7*A1-9 and format as a date.
--
Gary's Student


"Barbara" wrote:

Hi,
I have a column with a week number (15 for example) and i would like to
return this number in the format of date. Better: it has to be the Friday of
this week number.
Example : Week Date
15 07/04/2006

Hope that somenone can help me.
Tkanks,
Barbara

Don,
It gives an error on (2006,1,1). How can I fix it?


"Don Guillett" escreveu:

try this.
=DATE(2006,1,1)-WEEKDAY(DATE(2006,1,2))+B1*7

--
Don Guillett
SalesAid Software

"Barbara" wrote in message
...
Hi,
I have a column with a week number (15 for example) and i would like to
return this number in the format of date. Better: it has to be the Friday
of
this week number.
Example : Week Date
15 07/04/2006

Hope that somenone can help me.
Tkanks,
Barbara

"Barbara" wrote in message
...

"Barbara" wrote in message
...
Hi,
I have a column with a week number (15 for example) and i would like to
return this number in the format of date. Better: it has to be the
Friday
of
this week number.
Example : Week Date
15 07/04/2006

Hope that somenone can help me.
Tkanks,
Barbara

"Don Guillett" escreveu:

try this.
=DATE(2006,1,1)-WEEKDAY(DATE(2006,1,2))+B1*7

--
Don Guillett
SalesAid Software


Don,
It gives an error on (2006,1,1). How can I fix it?

What sort of error are you seeing?
The formula seems to work for me. Note that it gives 14/4/06 for week 15,
not 7/4/06 as you had suggested. [Week 1 gives 6/1/06] You may need to be
careful about what sort of week numbers you are using, see:
http://www.cpearson.com/excel/weeknum.htm
--
David Biddulph