Saturday, October 11, 2014

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   Oct-11-2014
post by  wbmatti:
Query Month Problem

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"))

Thanks a lot