Are you working today? or Do you have Work Off or holiday today?
I am asking this question because I am gonna tell you the most commonly used function in Excel “Workday”. “Workday” as name suggest that it brings the day when you will be working or you are expecting something to be done on a particular date. You can derive all these dates with the help of Excel Function Workday.
Suppose you do not want to work on Weekends or you have a list of holidays which should be excluded from the calendar you are working on, you can use this function. This function helps people to prepare list of dates excluding holidays/Weekends etc i.e calendar, project timelines, delivery date etc. You can also derive the next working day by keeping in mind your holiday list. Lets learn this function
The formula of the WORKDAY Function In Excel:
Syntax: =WORKDAY(start_date, days, [holidays])
Things to Remember:
– This function considers the Saturday and Sunday as default holiday and always exclude these but if you want to make customer define function. You can use WORKDAY.INTL function which is more robust.
Example – Suppose, 2nd Sep 2019 is a Start date and now we need to know the next working day.
2nd Sep 2019 is “Monday” and if we need the next working date (i.e. 1 day gap) then “days” argument will be “1” and will be following below Syntax:
=WORKDAY(A2,1,$D$2:$D$5)
Note: We added the holidays as sample in D Column, you can expand the list and increase the range in “Holidays” parameter. See below image:
Next working date to 2nd Sep 2019 (Monday) is 3rd Sep 2019 (i.e. Tuesday)
– In above similar example if we need the working day with 2 days gap. i.e. for 2nd Sep 2019 (Monday) and we need the next working date to “Wednesday”. Then “days” argument will be “2” and we will be following below Syntax:
=WORKDAY(A2,2,$D$2:$D$5)
You can see in Cell “B2” where we calculated the date 04th September. You can use number formatting to use desired date format
We are currently offering our Excel VBA Course at discounted prices. This 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.
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.
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
Hope you learnt this Function! you may comment in below comment box for any questions regarding this formula.
If you are liking our articles and want to learn more similar tricks, please do not forget to Subscribe us or follow us on Social Media by clicking below buttons.
Happy Reading!
COUNT function is used to get the total count of Number values in range or list.COUNT Function has one required and optional arguments.
An ultimate guide for basic user to understand Excel Vlookup function. VLOOKUP is a vertical lookup which helps the user to extract the values from other columns (leftmost) basis on matching column string.
MOD function is used to get the remainder of number that is divided by divisor. MOD Function has two required arguments i.e. number and divisor.
Excel Function REPLACE REPLACE function is used to replace the existing text from a specific location in a cell to New Text. REPLACE Function has argument four arguments i.e. old_text, start_num, num_chars and new_text. We need to give the…
Calculations With Date In Excel Dates function also be used to subtract the Year, Month and Days from the existing dates. Sometimes we need to subtract specific period from the date. In case you are…
UPPER function is used for changing the text/string to UPPER case in Microsoft Excel. The output of the function returns value in new cell.