Reporting week in Google Sheets?

Question

Google Sheets

I have a date by which I need to display the reporting week (Mon - Sun)
For example, the date in cell A1 is September 28, I need cell A2 to indicate which reporting week this date belongs to
A1 = 28.08.2019
A2 = 26.08 .2019 - 01.09.2019

Answer 1

Formula for cell A2:
=Text(A1-WEEKDAY(A1;2)+1;"dd.mm.yyyy")&"-"&Text(A1-WEEKDAY(A1;2)+7;"dd.mm.yyyy ")