Google Sheets. Turning Date into Day of Week
Did you know that there are plenty of tips and tricks that will surely make using Google Sheets easier and amusing? Today I would love to tell you about turning a date into a day of the week. Are you intrigued? Keep up with the video tutorial for better understanding and let’s go!
Formulas
We have a small table with data that will serve a basis for our formulas.
Weekday
First of all, there is a formula =WEEKDAY() that helps us find the number of the day of the week. It has 2 attributes — date and type. Date can be a link to another cell, formula or a text. Type is an optional attribute and by default it can be just 1.
As you see, in type 1 the first day is Sunday. In type 2 the first day is Monday. In type 3, Monday is day 0, consequently, Tuesday is day 1 and so on. As a result, the number of the day of the week will be determined according to the day of the starting of the week.
Extracting day from date
I have a separate article about it and you can read about day from date extraction in detail. But for now, let’s quickly review it.
- ‘=TEXT(Date, “D”)
You can extract a date from another cell as a date attribute. “D” stands for the day of the month in format “1”, “29” and so on.
2. ‘=TEXT(Date, “DD”)
In this case DD will always be a two-number day of the month. For instance: “01”, “08”.
3. ‘=TEXT(Date, “DDD”)
This formula will determine the shortened name of the day of the week, for example: Mon, Tue, Wed etc.
4. ‘=TEXT(Date, “DDDD”)
It allows us to get a full name of the day of the week.
I really hope you liked this article. Share your impressions in the comments section! Don’t forget to subscribe to our newsletter and check out our template store.
