Date Formula

[Guest]

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

 

[Guest]

Hi Barbara:

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

 

[johneva]

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.

 

[Don Guillett]

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

 

[Guest]

Thanks Gary
It works!!!

"Gary''s Student" escreveu:

 

[Guest]

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


"Don Guillett" escreveu:

 

[David Biddulph]

"Don Guillett" escreveu:

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