"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