Question

U={days of the week), A={Mon,Tue, Wed}. The compliment of A is
{Thursday, Friday, Saturday, Sunday
{Monday, Tuesday}
{Wednesday}
​

Answer 1

Answer:

MenuCorporate Finance Institute

WEEKDAY Function

Returns an integer that represents the day of the week for a given date

Home › Resources › Excel Resources › Functions › WEEKDAY Function

What is the WEEKDAY Function?

The WEEKDAY Function is an Excel DATE and TIME Function. The function will return an integer that is a representation of the day of the week for a given date.

WEEKDAY is quite useful in financial analysis. Suppose we wish to determine the time required to complete a certain project – the function can be useful in removing weekends from the given time frame. Thus, it is particularly useful when planning and scheduling work for a business project.

 

Formula

=WEEKDAY(serial_number,[return_type])

 

It uses the following arguments:

Serial_number (required argument) – This is a sequential number representing the date of the day that we are trying to find.

Return_type (optional argument) – This specifies which integers are to be assigned to each weekday. Possible values are:

 

Return_typeNumber returned1 or omittedIt will take Sunday as first day of week so, Sunday = 1, Monday = 2, ... , Saturday = 72It will take Monday as first day of week so, Monday = 1, Tuesday = 2, ... , Sunday = 73It will take Tuesday as first day of week so, Monday = 0, Tuesday = 1, ... , Sunday = 611Monday = 1, Tuesday = 2, ... , Sunday = 712Tuesday = 1, Wednesday = 2, ... , Monday = 713It will take Wednesday as first day of week so, Wednesday = 1, Thursday = 2, ... , Tuesday = 714It will take Thursday as first day of week so, Thursday = 1, Friday = 2, ... , Wednesday = 715It will take Friday as first day of week so, Friday = 1, Saturday = 2, ... , Thursday = 716It willl take Saturday as first day of week so, Saturday = 1, Sunday = 2, ... , Friday = 717Sunday = 1, Monday = 2, ... , Saturday = 7