Inverse to WEEKNUM

[Alonso]

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)

 

[Sean Timmons]

Maybe not the prettiest thing, but if you put 1/1/08 in B1 and 40 in A1,

=IF(WEEKDAY(B1+A1*7,1)=2,WEEKDAY(B1+A1*7,1),WEEKDAY(B1+A1*7,1)-WEEKDAY(B1+A1*7,1)+2)

should get you there.

 

[Don Guillett]

try this
=DATEVALUE("Dec 31, 2007")+($B$2-1)*7

 

[Teethless mama]

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

 

[Don Guillett]

Looks like the best one

 

[cprao]

Hi Mama
I am curious to know why you deducted 8 in the formula

 

[Alonso]

as Don says
looks like the best one

and above all
it worked perfectly

thanks!!

 

[Alonso]

thanks for the remark David

i noticed that your formula is similar
I'll keep both, just to track any changes

 

[Alonso]

David

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