Monday, July 7, 2014

yogi_From The Results Of The Query Function In Cell A3 Pull Month Names Rather Than Month Numbers in Cells B3 to D

                                   Google Spreadsheet   Post  #1692
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Jul-08-2014
post by ramkyc: (https://productforums.google.com/forum/?utm_medium=email&utm_source=footer#!msg/docs/hb3dKKdjCH8/YAoLJ-2xtwsJ)
How to get Month name from Month Number?
How to make the following command display the month name instead of the month number?
=query('Appeals Register'!A:Z, "select M, count(B) where Q >= date'2014-04-01' and Q <= date'2014-07-01' group by M pivot month(Q)", -1)

I want to have the name of the Month like "Apr", "May" etc reflect in the result of my query instead of getting the Month number like "3" or "4" which appears to be the default behaviour when I am using the above select query.  Searched quite a bit in the forum; but couldn't zero in on the solution.


My query is the second sheet titled "Hearing notices to issue" in cell A3.  The first sheet "Appeals Register" contains the actual data.

Thanks in advance.

Ramakrishna
--------------------------------------------------------------------------------------------------------------------------------------------


No comments:

Post a Comment