Date Range by a week number

[damon_albran]

Hello,

I am working on report with week number. Does anyone know how to make a calculation field that can show the start date and end date by supply a week number and year?

ie: Year 2005 Week 2 = Jan 2, 2005...Jan 8, 2005

Any help will be much appreciated!

Thanks!

[aaa]

It seem that this works:

Week_Begin=Date(01,01,Year)+8-DayofWeek(Date(01,01,Year))+(Week-2)*7

Week_End=Week_Begin+6

I tried.

Or is the same:

Week_Begin=Date(01,01,Year)+1-DayofWeek(Date(01,01,Year))+(Week-1)*7

Week.zip

[damon_albran]

I have tried and it works! many thanks!