Problem 5.5 Using VLOOKUP

In worksheet "Part 5" there are 10 major holidays and their date for 2020. You are to fill in the "Weekday" column, so you know what day of the week the holidays fall on in 2020. You MUST use the VLOOKUP function. (Hint: There is an excel function WEEKDAY() that will convert a date to a number 1-7).

A B C D Holiday Date Weekday 2 New Years 1/1/2022 3 MLK 1/17/2022 Valentines 2/14/2022 The Perfect Date 4/25/2022 6 Eid al-Fitr (Day 1) 5/1/2022 7 Juneteenth 6/19/2022 Dr. B.'s Birthday 6/21/2022 9 Independence Day (US) 7/4/2022 10 Labor Day 9/5/2022 11 Dr. BE's Due Date 9/9/2022 12 Gandhi's Birthday 10/2/2022 13 Thanksgiving 11/24/2022 14 Frist day of Hanukkah 12/18/2022 15 Christmas 12/25/2022 16 First day of Kwanzaa |12/26/2022 17