>>>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.
Does that the first week is defined as the week that contains Jan 1? Or the is first week with 4 days? IOW, you need to define what the first week is, from there the rest is what the others have told you.