## Friday, October 5, 2012

Question:

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?

Solution:

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:

I hope the above solution will help you, and if you need more help then please do comment below on this blog itself, I will try to help you out.

I also take up private or confidential projects:

If this blog post was helpful to you, and if you think you want to help me too and make my this blog survive then please donate here: http://igoogledrive.blogspot.com/2012/09/donate.html

Thanks,
Kishan,