First you need to settle on definitions. There are several conflicting definitions you have to address. Does your week start on a Sunday, or on a Monday? What defines the first week of the year (i.e., when does Week 1 start)? If I recall correctly (and it's been a while, so I might not), there's an ISO standard definition for numbering weeks that conflicts with standard business practice.
Get that settled for whatever problem you're dealing with, then generate a big lookup table.
In reply to Re: start and end date for a week
by dws
in thread start and end date for a week
by ganesh_saravanan
| For: | Use: | ||
| & | & | ||
| < | < | ||
| > | > | ||
| [ | [ | ||
| ] | ] |