Date Formula
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
|