Add an additional column in the Data tab, in which you convert Column A from DateTime to Date format with a formula. Prepare a table chart showing how many classic food boxes and how many veggie food boxes we sold

Please Tell me the steps on how this would be solved using Excel. Note that this is not the full excel data but just a small sample.

date_sign_up	customer_id	product_name	marketing_channel	City
4/17/2015 13:11	71041	Classic - 3 meals per week for 2 people	Search Engine Marketing	San Diego
4/14/2015 11:32	103289	Classic - 3 meals per week for 2 people	Newsletters (internal)	Los Angeles
4/14/2015 9:53	107746	Classic - 3 meals per week for 2 people	Newsletters (internal)	Los Angeles
4/14/2015 16:08	157441	Classic - 3 meals per week for 4 people	Newsletters (internal)	San Francisco
4/18/2015 8:04	158646	Classic - 3 meals per week for 2 people	Newsletters (internal)	San Diego
4/18/2015 15:41	178843	3 Meals (vegetarian) for 2 people	TV / Radio Advertising	Miami
4/15/2015 9:45	179297	Classic - 3 meals per week for 2 people	Newsletters (internal)	Philadelphia
4/15/2015 8:21	182439	3 Meals (vegetarian) for 2 people	Newsletters (internal)	San Francisco
4/17/2015 6:57	186180	Classic - 3 meals per week for 2 people	Partnership Marketing	San Diego
4/19/2015 20:39	190396	Classic - 3 meals per week for 2 people	TV / Radio Advertising	Miami
4/14/2015 10:26	194229	Classic - 3 meals per week for 2 people	Search Engine Marketing	Los Angeles
4/13/2015 20:17	194353	Classic - 3 meals per week for 2 people	Search Engine Marketing	Washington
4/15/2015 14:43	200286	Classic - 3 meals per week for 2 people	Search Engine Marketing	Philadelphia
4/16/2015 7:35	201307	Classic - 3 meals per week for 2 people	TV / Radio Advertising	1San Diego
4/15/2015 6:54	203319	Classic - 3 meals per week for 2 people	Newsletters (internal)	San Francisco
4/14/2015 8:35	205233	Classic - 3 meals per week for 2 people	TV / Radio Advertising	Los Angeles
4/13/2015 12:08	205322	Classic - 3 meals per week for 2 people	Newsletters (internal)	Chicago
4/16/2015 5:04	205611	Classic - 3 meals per week for 2 people	TV / Radio Advertising	San Diego
4/15/2015 12:17	208066	3 Meals (vegetarian) for 4 people	Newsletters (internal)	Philadelphia