Thread: Date Formula
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gary''s Student
 
Posts: n/a
Default 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