get weekstart date of calendar week

[#1]

hi,

i have the calendar week number and now I want to know with what date it starts and ends?? does anyone know how to do it??

regards,

MT

[swuehl]

Look into

MakeWeekDate(YYYY [ , WW [ , D ] ] )

Returns a date calculated from the year YYYY, the week WW and the day-of-week D.

If no day-of-week is stated, 0 (Monday) is assumed.

Examples:

makeweekdate(1999,6,6) returns 1999-02-14

makeweekdate(1999,6) returns 1999-02-08