RE: Date Formula

Giganews Newsgroups
Subject: RE: Date Formula
Posted by:  Gary''s Student
Date: Fri, 5 May 2006

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

Replies

In response to

Date Formula posted by Barbara on Fri, 5 May 2006