Ask Your Question

blairpeery's profile - activity

2019-01-12 22:10:28 +0200 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 +0200 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 +0200 received badge  Scholar (source)
2019-01-12 21:42:04 +0200 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 +0200 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 +0200 received badge  Popular Question (source)
2019-01-11 03:19:45 +0200 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