google sheets day of week This is a topic that many people are looking for. bluevelvetrestaurant.com is a channel providing useful information about learning, life, digital marketing and online courses …. it will help you have an overview and solid multi-faceted knowledge . Today, bluevelvetrestaurant.com would like to introduce to you Google Sheets Weekday Function 2018. Following along are instructions in the video below:
“To excellence in excel and in this video. We re going to focus on the the function with days. So this is a really nice function. Because you can analyze the weekday and based on a number so for example with weekday.
If you have let s say today today is 11 august 2018. Yes it s a saturday so we give a number to weekday and there are three main ways to do this and knowing. Which one you re going to use is important. So let me explain let s start and use here.
Let s say today enter all right so it s now august 11. And this is a saturday and if you really want to figure that one out we can do here right click. We can get some special design. Let s see if we can find them maybe.
It s here..
It s a publish on the format and then we have the number let s see if we can get any kind of design your currency date. Let s select more formats. Let s learn some more formats more date formats. And what we really want this we want to show here that this is a saturday.
All right this is the one we want apply this all right double click. And i ll just merge these cells together let s put them all. Together. Let s click your format and merge cells alright.
So we have this so we know now this is saturday 1100s. So let s put in a function week day once we do a week day. You can see there are the date you have to date. And you have the type so this is very important so i m going to select here.
And it s just selecting this one it understands this is it enter so by default..
It is weekday saturday is considered number seven. So this is the default function default or number. One. This is number two function.
And this is number three function. I m going to explain this you might wonder one. What is this exactly well let me show you so we have here. Now we have like this type.
The type is basically the numbering system to use to represent the weekdays. Very simple here saturday is considered number seven. If we do instead of this video. Say let s say plus 1.
So it s sunday sunday is considered number one however if you are like me..
It s very common you say the first day is monday and not sunday sunday s considered a 7. There or the last day of the week. So what do you do is here very simple. We have the option here if you put in 1.
Nothing changes here because it is exactly the same sunday still cause here number 1. But if you put it here now number 2. You can see now that sunday. Is now considered this here.
This is the structure here and of course. There s a final option. Here. Because there are only three options here number three then sunday is considered six because monday is count this number is zero.
Very very important to remember because i remember before when i use some complicated formulas..
Assuming by default. It was solid monday is considered number one and sunday was number seven. I got very wrong formula so make sure you pay attention on this. But that s video.
This is really just some very small minor item. But it will have a big impact on your on your formulas. Especially if you don t know the different things. However.
This is really how you use the weekdays. ” ..
Thank you for watching all the articles on the topic Google Sheets Weekday Function 2018. All shares of bluevelvetrestaurant.com are very good. We hope you are satisfied with the article. For any questions, please leave a comment below. Hopefully you guys support our website even more.