Ask Your Question

blairpeery's profile - activity

2019-01-12 22:10:28 +0100 commented answer How to find the Date of Sunday of the current week.

Thank you, Mike! I was not aware of the WEEKDAY() function, and it was just what I needed. Your formula works perfectly.

2019-01-12 22:09:52 +0100 marked best answer 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?

Thanks!

-Blair

2019-01-12 22:09:52 +0100 received badge  Scholar (source)
2019-01-12 21:42:04 +0100 commented answer How to find the Date of Sunday of the current week.

Thank you, Mike! I was not aware of the WEEKDAY() function, and it was just what I needed. Your formula works perfectly.

2019-01-12 21:39:56 +0100 commented answer How to find the Date of Sunday of the current week.

Thank you, Mike! I was not aware of the WEEKDAY() function, and it was just what I needed. Your formula works perfectly.

2019-01-11 11:32:21 +0100 received badge  Popular Question (source)
2019-01-11 03:19:45 +0100 asked a question How to find the Date of Sunday of the current week.

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 th