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

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.

  • 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 May 23 '19 at 13:56

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.