yogi_Convert Month Name Into Month Number For Formula Using QUERY Function

                  Google Spreadsheet   Post  #1786
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Oct-11-2014
post by  wbmatti:
(https://productforums.google.com/forum/#!category-topic/docs/spreadsheets/8RN9JDGTIGA)
Query Month Problem

Hi,

I am trying to build a Profit and Loss sheet with a dynamic forecast function.

Means, I want to show the profit or loss for the next months.

The Problem I have is the "where Month(D)=" function in the Cockpit sheet. (Cell C10)

Is there a way to make a formula like MONTH(D)="CELL" instead of MONTH(D)=10.

Cockpit!C10=SUM(query(Revenues!$A$1:$I$200; "Select C WHERE MONTH(D)=G19 AND E is NULL"))-SUM(query(Expenses!$A$1:$I$200; "Select C WHERE MONTH(D)=G19 AND E is NULL"))

https://docs.google.com/spreadsheets/d/1J2dVQTamYUwh5iI5JzylCwxgEXBIEj12LNSLGaHtX0w/edit?usp=sharing

Thanks a lot

-----------------------------------------------------------------------------------------------------------------