WeekStart & WeekEnd

[SergioS]

Why WeekStart('01/01/2020') returns 30/12/2019 and WeekEnd('31/12/2020') returns 03/01/2021 regardless the value of BrokenWeeks.

I'm expecting as results 01/01/2020 and 31/12/2020.

Thank you.

[Taoufiq_Zarra]

@SergioS  Weekstarts or weekend corresponds to the week's beginning

This function returns a value corresponding to a timestamp of the first millisecond of the first day (Monday) of the calendar week containing date

do you need MonthStart and MonthsEnd ?

[SergioS]

Hi Taoufiq, I am looking for a formula for weeks, not months. For every year YYYY it must return 1/1/YYYY for the first week, and 31/12/YYYY for the last week. Thank you.