Fantastic!! Thank you so much. I didn't read anywhere about the ampersand symbol, which would explain why I couldn't get it to work.
On Sun, 14 Jul 2019, 09:45 'Ray Thomas' via Google Visualization API, < [email protected]> wrote: > 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 > <https://groups.google.com/d/msgid/google-visualization-api/45594bdb-8a10-45d8-bebe-7014433d8090%40googlegroups.com?utm_medium=email&utm_source=footer> > . > For more options, visit https://groups.google.com/d/optout. > -- 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/CAFUpy6Hwrkjf7VMTMgB%3Dxkg9jy8vbKGwxRxYCjVKQ%2B03QwEW5g%40mail.gmail.com. For more options, visit https://groups.google.com/d/optout.
