The data below has a mixed format that is not clean. You are required to:

$$Exrtact the date in the format as shown in Column D using excel formulae.

$$In Column E$,$ use an Excel formula to extract the Aircraft company. The column from which you need to extract the company is Column B$.$

A sample is shown for the first row on what should be shown as a result of the Excel formula that you use.

F

G

$10$ points

ItS

$10$

date$\_$of$\_$occurrence

$11$

$5/16/2011$

$12$

$29\mathrm{.}03\mathrm{.}2020$

$13$

$20211231$

$14$

$20$APR$2014$

$15$

$29\mathrm{.}10\mathrm{.}2017$

$16$

$17$

$18$

$19$

$20$

$21$

$22$

$23$

$63,369$

type$\_$of

$\_$car

Tesla Model $3$

Chrysler $145-200$

Honda B$747-300$

Airbus A$320$

Aero AT$4-$LSA

description

Checkup

Oil Change

Auto Repair

Tire change

Oil Change