Question: Using the WEEKDAY and VLOOKUP FUNCTION Date you were born
| Using the WEEKDAY and VLOOKUP FUNCTION | |||||||||
| Date you were born | <== Enter the date of your birth in the date format of mm/dd/yyyy | ||||||||
| Weekday (number)of the date you were born | <== Use the WEEKDAY function to determine the weekday you were born. | ||||||||
| Weekday (name of the day) of the date you were born | <== Use the VLOOKUP function to find the number from C5 in the table below. | ||||||||
| Lookup Table | |||||||||
| 1 | Sunday | ||||||||
| 2 | Monday | ||||||||
| 3 | Tuesday | ||||||||
| 4 | Wednesday | ||||||||
| 5 | Thursday | ||||||||
| 6 | Friday | ||||||||
| 7 | Saturday | ||||||||
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
