I want to write a formula in Google Spreadsheet that look into the range between two dates and will display all dates which are all "Tuesday".
Is there a formula to do this?
Suppose you have dates in Cell B1 and Cell B2.
Then put the following formula in Cell C1:
=FILTER(ARRAYFORMULA(B1-1+ROW(INDIRECT("B1:B" & (B2-B1+1))));ARRAYFORMULA(CHOOSE(weekday(ARRAYFORMULA(B1-1+ROW(INDIRECT("B1:B" & (B2-B1+1)))));"Sunday";"Monday";"Tuesday";"Wednesday";"Thursday";"Friday";"Saturday"))="Tuesday")
The above formula will display you the dates in Column C which all will be Tuesdays.
Have a look at the following screenshot: