Ask Your Question

Revision history [back]

How to find the Date of Sunday of the current week.

In Calc, how can I display the date of the Sunday at the start of the current week?

Example: Today is Thursday, Jan 10, 2019. So the cell should display Jan 6, 2019, which was the Sunday of this week.

TODAY() only gives me the current day, and it will be offset from Sunday by a varying number of days. Any clever suggestions from the geniuses out there?