Convert Week number to dates.

[aliasger.q]

Hello Everyone,


For Example:

If today's date is 27/march/2012, so weeknum function will show you 14th week, but is there any way to show all 14th week's dates in


{workbook(1).range("A2:A8").value} field


can anyone help me to solve my problem.?


Thanks

 

[vasim]

Assuming you have date in A1 & =WEEKNUM(A1,2) in B1,


Type =IF(WEEKNUM($A$1+ROW()-1,2)=$B$1,$A$1+ROW()-1,"") in A2 and drag till A8

 

[Luke M]

Or, if you only have the week number in B1, and want to just assume that it's the current year:

=DATE(2012,1,(B1-1)*7+ROW(A1))

Copied down 7 cells.

 

[aliasger.q]

Great great great

Excell-ent.


Many Many Thanks,

Mr. Indian & Luke M.

 

[vasim]

You are welcome....

 

[Luke M]

You're very welcome, thanks for the feedback. =)