D 6 A The values for Date starting in F16 are all text Build a formule in cell G16 that will convert the contents of cel F16 into a valid date (.e. non text) The formule's output should update appropriately if the Date values change Then copy the formula in G16 down the column to 20 love your formulos intact. Do not paste special over any cells no need to change the formatting of column G... leave the format of G16G20 as date(e... 1/1/2018) 10 11 12 all calculations for this question should reside in the cells designated for this question (G16:20) 13 14 15 16 Date New Date Column VENDOR MARKET MARY MAIDS MADISON IMA HOUSTON CHAPTER HOUSTON TENNESSEE MOON BALTIMORE SURTEN EXCEL CHICAGO SURTEN EXCEL CHICAGO PRODUCT XYZ XYZ ARC DEF ABC Sales 1674 20180101 16754 20180101 8116 20171228 2401 20171230 24420 20180110 18 19 20 21 22 23 08 24 another question is below 26 27 28 The customer names that appear below contain extra spaces leading, trailing and within) The extra spaces are "normal spaces (.e., space bar spaces) Build a formule in cell 33 to remove the extra spaces but retain single spaces between last name, first name and between any separate parts of first name last name The formula's output should update appropriately if the Customer Names change Then copy the formula in C33 down the column to C38 Love your formulos in fact. Do not paste special over any cells Your results should match the image to the right. all calculations for this question should resisde in the cells designated for this question (C33:038 31 12 3 Corrected Customer Name Customer Name Hannah Van Brom Billy Ray Lawson Kyndra Abbot Bass John McAfoos Lancen Andrew Adam Drennan Customer Name Hannah Van Brom Billy Ray Lawson Kyndra Abbot Bass John McAfoos Lancen Andrew Adam Drennan Corrected Customer Name Hannah Van Brom Billy Ray Lawson Kyndra Abbot Bass John McAfoos Lancen Andrew Adam Drennan another question is below Save your work