(Solved): 3. Given an excel file of several thousand dates (one per line), write a pseudocode algorithm to e ...

3. Given an excel file of several thousand dates (one per line), write a pseudocode algorithm to extract and transform the values in each date field from the excel file into several different calculated fields including: I. day of the week II. day of the year (number) III. month IV. week V. quarter Vl. year Jour algorithm would then produce a new file with each row consisting of all the newly calculated fields. HINT, you may refer to date/time functions in JavaScript to assist in what you can assume in your pseudo code. Submission Instructions: lou may complete the pseudocode via a Word document and Flowcharts with Visio. But fter completing all three parts combine them in one pdf file and submit. The pdf file hould contain your Name, ID, Time, and Date of completion as a header of each page. Jpload a single pdf file. DO NOT zip.