software

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 Studentquot;Barbaraquot; wrote:

gt; Hi,
gt; I have a column with a week number (15 for example) and i would like to
gt; return this number in the format of date. Better: it has to be the Friday of
gt; this week number.
gt; Example : Week Date
gt; 15 07/04/2006
gt;
gt; Hope that somenone can help me.
gt; Tkanks,
gt; 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: www.excelforum.com/member.php...oamp;userid=34156
View this thread: www.excelforum.com/showthread...hreadid=539216try this.
=DATE(2006,1,1)-WEEKDAY(DATE(2006,1,2)) B1*7

--
Don Guillett
SalesAid Software

quot;Barbaraquot; gt; wrote in message
...
gt; Hi,
gt; I have a column with a week number (15 for example) and i would like to
gt; return this number in the format of date. Better: it has to be the Friday
gt; of
gt; this week number.
gt; Example : Week Date
gt; 15 07/04/2006
gt;
gt; Hope that somenone can help me.
gt; Tkanks,
gt; Barbara
Thanks Gary
It works!!!

quot;Gary''s Studentquot; escreveu:

gt; Hi Barbara:
gt;
gt; In A1 put the week number
gt; in A2 put:
gt; =38718 7*A1-9 and format as a date.
gt; --
gt; Gary's Student
gt;
gt;
gt; quot;Barbaraquot; wrote:
gt;
gt; gt; Hi,
gt; gt; I have a column with a week number (15 for example) and i would like to
gt; gt; return this number in the format of date. Better: it has to be the Friday of
gt; gt; this week number.
gt; gt; Example : Week Date
gt; gt; 15 07/04/2006
gt; gt;
gt; gt; Hope that somenone can help me.
gt; gt; Tkanks,
gt; gt; Barbara

Don,
It gives an error on (2006,1,1). How can I fix it?quot;Don Guillettquot; escreveu:

gt; try this.
gt; =DATE(2006,1,1)-WEEKDAY(DATE(2006,1,2)) B1*7
gt;
gt; --
gt; Don Guillett
gt; SalesAid Software
gt;
gt; quot;Barbaraquot; gt; wrote in message
gt; ...
gt; gt; Hi,
gt; gt; I have a column with a week number (15 for example) and i would like to
gt; gt; return this number in the format of date. Better: it has to be the Friday
gt; gt; of
gt; gt; this week number.
gt; gt; Example : Week Date
gt; gt; 15 07/04/2006
gt; gt;
gt; gt; Hope that somenone can help me.
gt; gt; Tkanks,
gt; gt; Barbara
gt;
gt;
gt;

quot;Barbaraquot; gt; wrote in message
...

gt;gt; quot;Barbaraquot; gt; wrote in message
gt;gt; ...
gt;gt; gt; Hi,
gt;gt; gt; I have a column with a week number (15 for example) and i would like to
gt;gt; gt; return this number in the format of date. Better: it has to be the
gt;gt; gt; Friday
gt;gt; gt; of
gt;gt; gt; this week number.
gt;gt; gt; Example : Week Date
gt;gt; gt; 15 07/04/2006
gt;gt; gt;
gt;gt; gt; Hope that somenone can help me.
gt;gt; gt; Tkanks,
gt;gt; gt; Barbara

gt; quot;Don Guillettquot; escreveu:
gt;
gt;gt; try this.
gt;gt; =DATE(2006,1,1)-WEEKDAY(DATE(2006,1,2)) B1*7
gt;gt;
gt;gt; --
gt;gt; Don Guillett
gt;gt; SalesAid Software
gt;gt;

gt; Don,
gt; 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:
www.cpearson.com/excel/weeknum.htm
--
David Biddulph