Home Computer Learn weekdays excel formula with example

Learn weekdays excel formula with example

1 min read
0
0
41
1ST.3 1

WEEKDAY

excel weekday

 

What Does It Do?

This function shows the day of the week from a date.

Syntax
=WEEKDAY(Date,Type)

Type : This is used to indicate the week day numbering system.
1 : will set Sunday as 1 through to Saturday as 7
2 : will set Monday as 1 through to Sunday as 7.
3 : will set Monday as 0 through to Sunday as 6.
If no number is specified, Excel will use 1.

Formatting

The result will be shown as a normal number.
To show the result as the name of the day, use Format, Cells, Custom and set
the Type to ddd or dddd.

Example

The following table was used by a hotel which rented a function room.
The hotel charged different rates depending upon which day of the week the booking was for.
The Booking Date is entered.
The Actual Day is calculated.
The Booking Cost is picked from a list of rates using the =LOOKUP() function.
excel formula weekday
Load More Related Articles
Load More By amitgupta
Load More In Computer

Leave a Reply

Check Also

How to Check BUSY Updates

How to Check BUSY Updates Company > Check BUSY Updates Check BUSY Updates option provid…