Tag Info

New answers tagged


To convert YYYY, MM, DD to an actual Date object, you need the DATE command. The following works: =filter(A6:F371,A6:A371>=DATE(2015,1,1),A6:A371<=DATE(2015,1,31)) But I see you want to filter based on dropdown entry. For this I would use MONTH function. For example, suppose cell J10 has validation rule: list of items 01 (January), 02 (February), ...


The value of GoogleFinance("CURRENCY:USDBRL") is the value of one US dollar in Brazilian currency. This needs to be multiplied by the dollar amount that you want to convert. So, if B5 is the USD amount, the formula =B5*GoogleFinance("CURRENCY:USDBRL") will give the equivalent amount in Brazilian currency.

Top 50 recent answers are included