Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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