In this case, the WORKDAY function returned the date ‘’, you can verify using the calendar below: Instead of 7, pass -7 to our WORKDAY function and it will return to you the 7th working day before the provided start_date. What if you wanted to know the 7th working day before start_date? Note that June 21 is one of the holidays and is listed in column G. You can quickly verify this by checking the calendar like the example below: This means that it’s the 7th working day from the order date ‘’ excluding holidays. The return value of the WORKDAY function in our example above is the date ‘’. In this case, he put all the holidays for the year 2021 in column G from the second row until the 34th row. Lastly, the third argument is an optional list of holidays that also Seth didn’t want the WORKDAY function to include in counting. Hence, Saturday and Sunday are not included. Please note that the WORKDAY function only counts working days. The second argument is integer 7, which tells the WORKDAY function the number of working days it needs to add from the start_date. In this case, it is the order date of the item. The first one is the start_date, which tells the WORKDAY function where to begin counting. He just passed three arguments to our function. Let’s take a look at the example in the second row. This excludes the holidays, which were listed in column G. The delivery dates in column D are 7 days from the order dates in column C. Notice in Seth’s table that he was able to identify the delivery date using the WORKDAY function. Let’s take a look at the simple database that Seth created below to see how the WORKDAY function is used in Google Sheets. This is the list of dates that should be considered non-work days. If we enter a positive value, it will give us a future date, while a negative value will yield a past date. days is the number of workdays to be added to start_date.start_date is the date from which to start.It returns a date N working days in the future or past. WORKDAY () this is our WORKDAY function.It is how Google Sheets understand that we are asking it to either do computation or use a function. = the equal sign is just how we start any function in Google Sheets.Let’s dissect this thing and understand what each of these terms means: So the syntax (the way we write) of the WORKDAY function is as follows: =WORKDAY(start_date, days, ) Perfect! Let’s begin getting to know more about our WORKDAY function in Google Sheets. Watch out for a more advanced tutorial and examples on how you can use the WORKDAY function in the coming weeks. Not only that it saved him from tedious work, but the WORKDAY function is also convenient for him since it considers the holidays. With the help of the WORKDAY function, Seth was able to identify each order’s delivery date. He created a database of the orders for him to track easily and so that he can do necessary follow-ups to the third-party courier should there be any unforeseen delays in the delivery. He mentions to his clients that for orders coming overseas, the package should arrive 7 working days from the order date, excluding holidays. Seth owns an online store and caters to international deliveries. It is recommended that for the dates arguments, they should be entered as either reference to cells containing dates or dates returned from formulas.The function will return the #VALUE error when the dates arguments are not valid dates and the days provided are non-numeric.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |