OK, suppose your column A contains the dates and cell B1 contains the number of the month you want, then you can use
=QUERY(A:A, "select * where Month(A)="&B1&"") It looks a bit strange but that's the way the cell values are referenced in the queries. As a side note, if you use a query like this to use text in a cell to do some sort of comparison and that text contains a space then you need to add single quotes around "&B1&" so it becomes '"&B1&"' -- You received this message because you are subscribed to the Google Groups "Google Visualization API" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/google-visualization-api. To view this discussion on the web visit https://groups.google.com/d/msgid/google-visualization-api/45594bdb-8a10-45d8-bebe-7014433d8090%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
