David

for year 2009
what changes should be made to the formulas
either your's or mama's


"David Biddulph" wrote:

.... providing that YEAR(TODAY()) is 2008, so in that case you could use
=DATE(2008,1,1)-8+(A1)*7

For other years, you need one of the other formulae suggested (or alter
the -8 parameter).
--
David Biddulph

"Alonso" wrote in message
...
as Don says
looks like the best one

and above all
it worked perfectly

thanks!!


"Teethless mama" wrote:

=DATE(YEAR(TODAY()),1,1)-8+(A1)*7


"Alonso" wrote:

I know that using the function WEEKNUM you can get the number for a
week
through a year

eg. =WEEKNUM(09/29/2008) gets 40

my question is
can it be done backwards??

what i want to do is
type the number of the week (A1)
and get the date of the monday of that week (on B1)

ie
if i type 41
i should get 10/06/2008
(the date of the monday of week 41)