Question: Set-up a data validation rule that ensures that a person can enter only dates into cell B1 that are on a Monday or Tuesday only.

Set-up a data validation rule that ensures that a

Set-up a data validation rule that ensures that a person can enter only dates into cell B1 that are on a Monday or Tuesday only. For bonus marks can you identify the day of week in cell B2.

B1 fx B C D 1 Enter Date 2 Day of Week 3 3 4 5 6 7

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 General Management Questions!

Solve the problems below using your HP-12c. Write down the calculator keystrokes, and clearly identify your answers. Answers alone will not receive full credit. 1. A prospective tenant is evaluating...

FACT SHEET FOR YOUR CONFERENCE ASSOCIATION NAME: Statistics Notes Name of Conference: List the name you are going to give your conference, this will be used in all of your marketing (HTM 2025 Annual...

My name is Salam Abdulhussein and I need this to be done as soon as possible. Please follow the steps one by one and make sure everything is correct Global Bike, Inc. ERP for Sales / Collection USING...

could someone please help me these access assignment Accounting Information Systems Access Assignment S&S Revenue Database Introduction to Microsoft Access: Microsoft Access is representative of...

Need ONLY an answer to Part C, step 1, questions 1 and 3. Term Project Part A: Understanding Financial Statements Locate and use an annual report STEP 1: The Company Assigned to you Find the most...

You want to apply a subtotal to a dataset containing names, departments, and salaries. What is the first step you need to do? (a) Filter the dataset by salaries (b) Select the function to be used for...

Just need answer to part C question step 1, chart of accounts(1st question in step 1). Only need answer to that. Term Project Part A: Understanding Financial Statements Locate and use an annual...

Need the answer to Part C question only questions regarding the Step 2 - 7th question. Term Project Part A: Understanding Financial Statements Locate and use an annual report STEP 1: The Company...

Only Need a the answer for STEP 1 of "PART C" Need a sample answer doesn't have to be extremely detailed or anything. Term Project Part A: Understanding Financial Statements Locate and use an annual...

Increasingly, companies and employers are allocating their resources in ways that enable them to become change agents in community mental health. However, corporate entities with profit-based...

In its first month of operations, Kingbird, Inc. made three purchases of merchandise in the following sequence: (1) 800 units at $4, (2) 850 units at $6, and (3) 950 units at $7. Calculate average...

Debt financing fees incurred for an LBO deal are a ( n ) : Question 1 5 options: Deferred liability on the liability side of balance sheet Current liability One - time transaction fee on the income...

Hugo decides to buy his Christmas gifts on Black Friday. To simplify his life, he is giving his 10 closest friends scarves for Christmas and everyone else Christmas cards. Hugo is willing to pay up...