It will return a number representing the day of the week of the date provided. WEEKDAY() this is our WEEKDAY function.It is how Google sheets understand that we are asking it to either do computations 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) the WEEKDAY function is as follows: =WEEKDAY(date, ) Perfect! Let’s begin getting to know more about our WEEKDAY function in Google Sheets. Watch out for a more advanced tutorial and examples on how you can use the WEEKDAY function in the coming weeks. This is shown in column D with the total pay amounting to $155.50 Otherwise, we will use the weekends’ hourly pay rates. If the value is less than six, we will use the weekdays’ hourly pay rates. With the data provided by the WEEKDAY function, John just had to multiply the hours worked to the equivalent pay rates using the same process we did in the previous example. Although, in this case, John used the 2nd type for numbering the days, this values the days starting from Monday(1) to Sunday(7). The WEEKDAY function was used this time to put a value on the specific day John worked shown in column B. This example is similar to the previous one, except this time, we have to take into consideration the hours worked and the week starts on Monday. However, the job offers a different pay rate for weekends. John was asked to provide an invoice for his weekly payout. Lastly, if the value is 7, then we use the Saturday rates.Īs you can see in column C, I was able to come up with the total bill of $529.95. If the value is exactly 6, then the rate is for Friday. What I did after to take advantage of the data provided by the WEEKDAY function, I just had to use the IFS function to determine the equivalent rates, in this case, we had 3 arguments.įirst is if the value is less than 6, it is equivalent to the Sun – Mon rates. In this case, I use the default type that returns a value between 1 to 7 that starts on Sunday. Using the WEEKDAY function in Google sheets, I was able to put a value on the specific days the customer checked in as shown in column B. He is about to check out today and I need to determine her total bill. One customer stayed in our hotel for a total of five days. It will return a numerical value ranging from 0 to 6 or 1 to 7, depending on your preference. ‘Sat’ or ‘Sun’), or a full day name (e.g. The WEEKDAY function does not return a letter (e.g.Dates that are directly passed to the WEEKDAY function should be enclosed with quotation marks.The data that will be referenced on the WEEKDAY function should either be a cell that contains a date, a function that returns a date like DATE(), or an inputted data in a date format that Google sheets can recognize(e.g.The rules for using the WEEKDAY function in Google Sheets are as follows: How to Use WEEKDAY Function in Google Sheets.A Real Example of Using WEEKDAY Function.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |