Google Spreadsheet Formula for Weekend Dates

0

In Google Sheets, what formula can I use to create a list of weekend dates where each row shows the next upcoming Sat/Sun as follows:

05/18/2019 - 05/19/2019
05/25/2019 - 05/26/2019
06/01/2019 - 06/02/2019

THE DOCTOR

Posted 2019-05-22T22:08:54.967

Reputation: 191

Answers

1

In A1 enter:

=TEXT(date(2019,5,18)+7*(row()-1),"mm/dd/yyyy") & "-" & text(date(2019,5,19)+7*(row()-1),"mm/dd/yyyy")

and copy downwards.

enter image description here

Similar to Excel.

Gary's Student

Posted 2019-05-22T22:08:54.967

Reputation: 15 540

Thank you so much! This is great and teaches me a lot about how to create variations of this as needed in the future. – THE DOCTOR – 2019-05-23T13:56:10.813

Asked: 2019-05-22T22:08:54.967

Viewed: 53 times

Active: 2019-05-22T23:26:01.643