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 blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!