The WEEKDAY function

The WEEKDAY function is a date and time function which returns the day of the week on which the input date falls. The number representing each day of the week can be specified in the function.

This is the format of the WEEKDAY function:

=WEEKDAY(DATE VALUE, RETURN TYPE)

Here is an example of the WEEKDAY function:

=WEEKDAY(43335, 1) = 5 

WEEKDAY function returning the numeric representation of each day of the week starting with Sunday = 1

This function is valuable when looking into weekly trends such as distribution of sales or traffic across a period of time. Understanding these trends allows for budgeting and resource investment when it is required.

An example of a functional implementation of this would be determining scheduling budgets for stores based on their unique needs. Each store has historical data on their sales, and traffic for each day. Once you add the weekday to each row, you can average the data for each metric using a pivot table.

=WEEKDAY(B2, 1)