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?
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
- the first
sequencecreates a column of Wednesdays
- the second
sequencecreates a Sundays column
curly bracketsthat enclose the 2 sequences are used to create the range that the
Flattenfunction will then unify in a single column