|Subject:||RE: Date Formula|
|Posted by:||Gary''s Student|
|Date:||Fri, 5 May 2006|
In A1 put the week number
in A2 put:
=38718+7*A1-9 and format as a date.
> 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.
Date Formula posted by Barbara on Fri, 5 May 2006