New answers tagged microsoft-excel
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), ...
Add the following formula to the cell C1, and fill down as necessary =IF(A1="keyword",B1*2,B1) References IF - Google Editors Help
Top 50 recent answers are included