-1

I am new to Google Sheets and I am making a chart. I need all the Wednesdays and Sundays in date format in a column, but I cannot find any online tutorials. Can I please have some help?

1

1 Answer 1

1

If in A2 we insert the number of weeks to be taken into consideration and in B2 we insert the Wednesday of the beginning of the sequence, we could solve with this formula

=flatten({sequence(A2,1,B2,7),sequence(A2,1,B2+4,7)})

sequence

Link to the test file

Explanation

  1. the first sequence creates a column of Wednesdays
  2. the second sequence creates a Sundays column
  3. the curly brackets that enclose the 2 sequences are used to create the range that the Flatten function will then unify in a single column

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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