May 17, 2022

WEEKDAY Excel Function | How to Use WEEKDAY Function?

In this video on WEEKDAY Excel Function, here we discuss the WEEKDAY Formula in excel and how to use WEEKDAY Function along with excel example.

𝐖𝐄𝐄𝐊𝐃𝐀𝐘 𝐅𝐮𝐧𝐜𝐭𝐢𝐨𝐧 𝐢𝐧 𝐄𝐱𝐜𝐞𝐥

Weekday function in Excel is a function that returns a numerical value from 1 to 7, which identifies the day of the week as input for a date.

The function of Excel Weekday is classified as the date / time function.

𝐖𝐄𝐄𝐊𝐃𝐀𝐘 𝐅𝐨𝐫𝐦𝐮𝐥𝐚 𝐢𝐧 𝐄𝐱𝐜𝐞𝐥

Below is formula of weekday function in excel

= WEEKDAY (serial_number, [return_type])


serial number = Required input and it is a date value that we want the week’s day.

return_type = It is an optional field, a value ranging from 1 to 17 is an argument specifying the result day numbering system.

𝐓𝐡𝐢𝐧𝐠𝐬 𝐭𝐨 𝐑𝐞𝐦𝐞𝐦𝐛𝐞𝐫 𝐰𝐡𝐢𝐥𝐞 𝐮𝐬𝐢𝐧𝐠 𝐖𝐄𝐄𝐊𝐃𝐀𝐘 𝐅𝐮𝐧𝐜𝐭𝐢𝐨𝐧 𝐢𝐧 𝐄𝐱𝐜𝐞𝐥

#1 – The return type is always 1 by default if we omit return type, then the default value of WEEKDAY is 1.

#2 – If the serial number or return type as specified above is out of range, # NUM! Error is obtained.

To know more about 𝐖𝐄𝐄𝐊𝐃𝐀𝐘 𝐄𝐱𝐜𝐞𝐥 𝐅𝐮𝐧𝐜𝐭𝐢𝐨𝐧, you can go to this 𝐥𝐢𝐧𝐤 𝐡𝐞𝐫𝐞:-

Subscribe to our channel to get new updated videos. Click the button above to subscribe or click on the link below to subscribe –


Xem thêm bài viết:

Leave a Reply

Your email address will not be published. Required fields are marked *