# 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

edit retag close merge delete

Sort by » oldest newest most voted

=TODAY()-WEEKDAY(TODAY())+X

more

In your case (where the week obviously starts with Sunday), the WEEKDAY would be used with a single parameter, and the value of X would be 1 for Sunday.

( 2019-01-11 06:31:56 +0200 )edit

I thought of =TODAY()-WEEKDAY(TODAY(),2) Was bit confused of X :)

( 2019-01-11 06:34:49 +0200 )edit

(Spoken aside)
There is an international standard (ISO 8601) to the effect that monday is day number one and sunday is day number seven of any week. Such standards are thoroughly considered, negotiated, and published then. It might not be a good idea to ignore them. The way WEEKDAY() is used to number days should comply with the numbering of weeks over the year. The concept of numbering weeks (much used in business) only can be trusted if everybody numbers weeks the same way - and lets them start with monday.
@SM_Riga: To get the date of "today if a sunday, but last sunday otherwse" with the ISO numbering of weekdays would require the formula =TODAY()+7-WEEKDAY(TODAY();2)
(Just for fun?)

( 2019-01-11 11:29:31 +0200 )edit

Thank you, Mike! I was not aware of the WEEKDAY() function, and it was just what I needed. Your formula works perfectly. And thanks to SM_Riga and Lupp for good discussion. I consider this question answered in full. Happy New Year to all! :-)

( 2019-01-12 21:39:56 +0200 )edit