I am collecting responses from a form and would like to separate them into different tabs based on the month of the timestamp on the response. Kinda lost on using the date/ month function in the query. Would greatly appreciate any help.

Here is a sample of my spreadsheet: https://docs.google.com/spreadsheets/d/1MSD6F-MBixbaca7Jh_2bLSMPe23GHsndPVZkz60CUHU/edit?usp=sharing


1 Answer 1


OP is unregistered and does not show as having revisited since posting the above so since there seems very little chance of clarification I'm guessing that something like the following may suit:

=query(Sheet1!A:J,"select * where month(A)=7")

Here months count from 0 (for January).


Your Answer

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

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