Tomatoes originated from the Andes, in what is now called Peru, Bolivia, Chile and Ecuador - where they grew wild. They were first cultivated by the Aztecs and Incas as early as 700 AD.
1. Click any single cell inside a data set. 2. On the Data tab, click Filter. Arrows in the column headers appear. 3. Click the arrow next to Date. 4. Click on Select All to clear all the check boxes, click the + sign next to 2012, and click the check box next to January. 5. Click OK. Result.
Answer: You can remove the time portion from a date by using the YEAR function, MONTH function, and DAY function. In this example, we have a date/time value in cell A1 and we'd like to remove the time portion from this value. The order of how you use the Year, Month, and Day functions will depend on how you're formatting your date.