>>Hi everybody,
>>
>>Given 52 weeks in a year and week definition (from Sat through Friday) I need to calculate Week's first day, week's last day and some other dates for the given year for each week. What would be a formula here?
>>
>>Thanks a lot in advance.
>
>How is week 1 defined? Is the first week with a Sat, the first week with 4 or more days, the week with Jan 1?
The first week could be a prior year. Say, Jan 1st is Monday, so Sat. will be Dec.30 of the previous year.
If it's not broken, fix it until it is.
My Blog