TASK 2 (OF 2)The day of the week for a given date can be determined using the following expression:w = (k+ 126 m - 0.2) – 2-c +Y+ H+ ) mod 7where:kis the day of the monthm is the month (March = 1, April = 2,., December = 10, January = 11, February = 12)Cis the century (i.e the hundreds and thousands place in the year; 1982 → 19)Y is the year in the current century (i.e. the tens and ones place in the year; 1982 → 82)W is the day of the week (Sunday = 0, Monday = 1,.Saturday = 6)Additionally, the | J brackets in the equation mean that the value inside should be roundeddown to the nearest whole number.Please code in Excel VBA• Create a function called Year2Century that takes the year as an input and returns thecentury.• Create a function called Year2Year that takes the year as an input and returms the year inthe current century.• Create a function called Month2Val that takes the current month as a string and returnsthe corresponding month value as defined above.• Create a function called DayorWeek that takes as input the day of the month (1-31), themonth (as a string), and the year and, using the three functions defined previously, returnsthe day of the woek, as a string.• Use your DayorWeek function in an Exel formula (not a macro) to determine the daysof the week for the dates included in the worksheet.D EF GADates:Day of WeekNovember181928May171845NOTE: Remember that the modulus operator in VBA is the word Mod. Also, there is an Excelcommand called RoundDown that allows you to round down to the nearest whole number.January41642July151099September61966The algorithm provided is off by one day if you choose January and February. However, it isaccurate for March through December. There is a way to adjust the algorithm to account for this,but since the assignment has already been released, the algorithm given in the assignment shouldbe used.

Click on Developer tab From Code group, select Visual Basic click on insert

TASK 2 (OF 2) The day of the week for a given date can be determined using the following expression: w- (k+ 126 m - 02) – 2-C+Y+ H + D • mod 7 where: kis the day of the month m is the month (March = 1, April = 2,., December = 10, January = 11, February = 12) Cis the century (i.e the hundreds and thousands place in the year; 1982 → 19) Y is the year in the current century (ie. the tens and ones place in the year; 1982 → 82) W is the day of the week (Sunday = 0, Monday = 1,. Saturday = 6) Additionally, the | I brackets in the equation mean that the value inside should be rounded down to the nearest whole number. Please code in Excel VBA Create a function called Year2Century that takes the year as an input and returns the century. • Create a function called Year2Year that takes the year as an input and returms the year in the current century. • Create a function called Month2Val that takes the current month as a string and returns the corresponding month value as defined above. • Creale a function called DayOrWeek that lakes as input the day of the month (1-31), the month (as a string), and the year and, using the three functions defined previously, returns the day of the week, as a string. • Use your DayOrweek function in an Excel formula (not a macro) to determine the days of the week for the dates included in the worksheet. B D E F G Dates: Day of Week November 18 1928 Мay 17 1845 January 1642 NOTE: Remember that the modulus operator in VBA is the word Mod. Also, there is an Excel command called RoundDown that allows you to round down to the nearest whole number. July September 15 1099 6. 1966 The algorithm provided is off by one day if you choose January and February. However, it is accurate for March through December. There is a way to adjust the algorithm to account for this, but since the assignment has already been released, the algorithm given in the assignment should be used.

8th Edition

ISBN:9781337102087

Author:D. S. Malik

Publisher:D. S. Malik

Chapter8: Arrays And Strings

Section: Chapter Questions

Problem 10PE