Ask Your Question
0

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

asked 2019-01-11 03:19:45 +0100

blairpeery gravatar image

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 flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted
1

answered 2019-01-11 06:15:36 +0100

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

edit flag offensive delete link more

Comments

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.

Mike Kaganski gravatar imageMike Kaganski ( 2019-01-11 06:31:56 +0100 )edit

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

SM_Riga gravatar imageSM_Riga ( 2019-01-11 06:34:49 +0100 )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?)

Lupp gravatar imageLupp ( 2019-01-11 11:29:31 +0100 )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! :-)

blairpeery gravatar imageblairpeery ( 2019-01-12 21:39:56 +0100 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2019-01-11 03:19:45 +0100

Seen: 35 times

Last updated: Jan 11