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.
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.
Database System Concepts
7th Edition
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Chapter1: Introduction
Section: Chapter Questions
Problem 1PE
Related questions
Concept explainers
Max Function
Statistical function is of many categories. One of them is a MAX function. The MAX function returns the largest value from the list of arguments passed to it. MAX function always ignores the empty cells when performing the calculation.
Power Function
A power function is a type of single-term function. Its definition states that it is a variable containing a base value raised to a constant value acting as an exponent. This variable may also have a coefficient. For instance, the area of a circle can be given as:
Question
Transcribed Image Text: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 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 (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 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.
• Create a function called DayorWeek that takes 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 woek, as a string.
• Use your DayorWeek function in an Exel formula (not a macro) to determine the days
of the week for the dates included in the worksheet.
D E
F G
A
Dates:
Day of Week
November
18
1928
May
17
1845
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.
January
4
1642
July
15
1099
September
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.
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 3 steps with 5 images
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.Recommended textbooks for you
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education