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
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!
Microsoft Excel “TODAY” function is used to get the current Date. It is very useful function and can be used in many ways. “TODAY Function” does not have any argument that makes this easy to apply and implement.
In this tutorial, we’re going to explore one of the most intriguing features in Excel: the OFFSET function.
So, what is the OFFSET function in Excel? Simply put, OFFSET gives you a reference to a range of cells that’s moved from a starting point by a certain number of rows and columns.
LOWER function is used for changing the format of any text or string to LOWER case.
AND, OR, NOT Functions” provide result in “TRUE” or “FALSE”. If the logical condition is correct and matching the parameters provided, then result would be “TRUE” or if logical condition is not correct and not matching the parameters provided then result would be “FALSE”
In this tutorial you’ll learn how to use the TEXTBEFORE function in Excel to quickly get the text before a specific character or word.In older versions of Excel, this was more difficult. You had to…
COLUMNS function is used to get the total count of columns in an array or in cells range for excel worksheet.