Automatically find the beginning and end of a work week in a Google spreadsheet

Question

My work week goes from Monday to Sunday, and I need to find a way to automatically update 2 different cells based on = today (), what is the actual start and end date of the current work week.

Is there a formula that can find this?

Similarly:

Is there a similar method for automating the first and last days of the current month in different cells?

Thank you in advance for your help.

Answer 1

Assuming you are referencing a date in A1 ...

Beginning of the work week containing this date (provided that the work week starts on Monday):

=A1-WEEKDAY(A1;3)

End of work week:

=A1-WEEKDAY(A1;3)+6

Beginning of the month:

=EOMONTH(A1;-1)+1

The end of the month:

=EOMONTH(A1;0)

I know this is Microsoft Excel documentation, but this> describes the EOMONTH function.