Get Fridays date of the given week number

[prasadsg2005]

Hello,

Is it possible to get Fridays date of Week Number 38,39,40 and So on..

THnaks,
Prasaad Gaikwad.



[TABLE="width: 93"]
<tbody>[TR]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: right"][/TD]
[/TR]
</tbody><colgroup><col></colgroup>[/TABLE]

 

[portews]

put the week number in A1 and it will give you the date for the current year.

=CEILING(DATE(YEAR(NOW()),1,1)-6,7)+(7*A1)-1