google spreadsheet - Have only Tuesdays and Fridays repeating -
is possible drag repeating pattern of tuesdays , fridays repeating in google sheets? type of output i'm looking this:
tuesday, june 2, 2015
friday, june 5, 2015
tuesday, june 9, 2015
friday, june 12, 2015
...
and drag down continue pattern... when now, continues incrementing number of days between tuesday , friday.
thanks!
maybe can try formula:
=query(arrayformula({(date(2015,6,2)+row(a1:a1000)-1), weekday(date(2015,6,2)+row(a1:a1000)-1,2)}), "select col1 col2 matches '"&join("|", 2, 5)&"' limit 10")
where date() function holds starting date , limit part limits output whatever number want. see if works ?
edit: if want tuesdays , fridays list of dates in col a, try:
=filter(a2:a, (weekday(a2:a)=3)+(weekday(a2:a)=6))
then copy output , paste in col 'values only'.
Comments
Post a Comment