>>>>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.
The first week is the week, containing Jan 1. I used Steve's idea and calculated all dates. I'll give these dates to my colleague to review.
If it's not broken, fix it until it is.
My Blog