Excel Function WEEKDAY
WEEKDAY as the word suggest it is “Day count in a week”. WEEKDAY function applies to a Date and returns the output for Day of the week. The output of the function varies from 0 to 7 and by default WEEKDAY function takes “Sunday to Saturday” as a week and counts Sunday as 1st Day till Saturday as 7th Day.
WEEKDAY Function has two arguments i.e. serial_number and return_type, are easy to apply and implement. Function should give output in number format, however if output is not as per the desired format then we need to change the cell format to “GENERAL”. We will be discussing the steps that how we can change the cell format to GENERAL in detail.
If input value is not in date format then the output of the function will return to “#VALUE!”. So always ensures that the input data range is in correct format to get the appropriate results/output.
Advantage of WEEKDAY Function
WEEKDAY function is very advantageous in many ways. It helps for the document where weekday sequencing is required in more often. Applying weekday count manually (one by one) to a report is very difficult and WEEKDAY Function helps to apply the function in large database at once and makes the work easy, saves time and increases efficiency.
Where WEEKDAY function can be used:
WEEKDAY Function is very useful and can be used in many places. Like it can be used as follows:
– Preparing employees and wages summary, where wages are paid weekly
– Employees utilization or productivity, attendance tracker on weekly basis
– Or any other database where there is requirement of count of days in a week, WEEKDAY Function” can be used
Syntax:
=WEEKDAY(serial_number,[return_type] )
Syntax Description:
There are two arguments i.e. serial_number and return_type. Below are the details of each arguments:
serial_number argument, is used to give cell reference where date is mentioned and weekday to be counted.
return_type [Optional] argument, is a optional argument is used to give reference to selection of week period. by default it takes “Sunday to Saturday” as a week and counts Sunday as 1st Day till Saturday as 7th Day, however if week period is different than “Sunday to Saturday” return type argument can be used.
Below is the list of return_type and explanation:
Example 1: Calculate Weekday for a Date applying default “return_type” argument.
Suppose we have a date i.e. Monday, 23rd March 2020 and need to identify what is count of week for the said date. We will be using the default week i.e. Sunday to Saturday while applying the function.
Explanation: We can see the output of the function returns as 2. Because while considering a week of Sunday to Saturday, Sunday is 1st day and Monday is 2nd Day.
Example 2: Calculate Weekday for a Date applying 2 as “return_type” argument.
With the same date i.e. Monday, 23rd March 2020 and need to identify what is count of week for the said date. We will be considering “return type = 2” i.e. Monday to Sunday while applying the function.
Explanation: We can see the output of the function returns as 1. Because while considering a week of Monday to Sunday, Monday is 1st day.
Example 3: Evaluating a date with ALL as “return_type” argument.
Here we are evaluating a date i.e. Monday, 23rd March 2020 with All “return type” argument
Explanation: We can see the output of the function with various “return_type” returns value between 0 to 7.
Things to Remember:
If output is not as per the desired format then we need to change the cell format to “GENERAL”. Follow below steps to change the format of the cell:
Step 1: Select the Cell or Data Range
Step 2: Press Ctrl + 1 to open “Format Cells” option
Step 3: Select the option to “General”
This will change the format of the cell to desired format.
Hope you learnt this Function!
Don’t forget to leave your valuable comments!
If you are liking our articles and want to learn more similar tricks, please Subscribe us
Download Practice File
Recommended Articles
Secrets of Excel Data Visualization: Beginners to Advanced Course
Here is another best rated Excel Charts and Graph Course from ExcelSirJi. This courses also includes On Demand Videos, Practice Assignments, Q&A Support from our Experts.
This Course will enable you to become Excel Data Visualization Expert as it consists many charts preparation method which you will not find over the internet.
So Enroll now to become expert in Excel Data Visualization. Click here to Enroll.
Excel VBA Course : Beginners to Advanced
We are offering Excel VBA Course for Beginners to Experts at discounted prices. The courses includes On Demand Videos, Practice Assignments, Q&A Support from our Experts. Also after successfully completion of the certification, will share the success with Certificate of Completion
This course is going to help you to excel your skills in Excel VBA with our real time case studies.
Lets get connected and start learning now. Click here to Enroll.
Use Automated Excel Utility Tools to increase productivity
- Quickly Move or Delete Files or Folder >> Click here
- Handle Duplicate Files with Automated Utlity >> Click here
- Generate Dummy Data For Testing >> Click here
- Excel Files and Sheets Consolidator >> Click here
- Manage Outlook Emails efficiently >> CLick here
- Send Bulk Emails wiht our Excel Automation >> Click here
Hope you are enjoying learning Excel with us, if you want any support related to this article, please do comment else you can ask questions in Excel Community
