How to Know the Day of the Week of Any Date

0:00 We have the date of the holiday, but we want to know the weekday, like Monday, Tuesday, Wednesday, and if we're going to use the formula weekday, we can put in the date, and we have a type here, but check out the types, the types just refer to a number , so we can put in one here, and we can get a number . If we have this, we need to create a little VLOOKUP table , let's say. And we need to correspond to the number of day of the week. So we can create this here, or we can create it some other tab if we want. But this is all very complicated. We're going to have to do 1, 2, 3, 4, 5, 6, 7. And we're going to have to do equals Sunday, Switch Data Figure Out Frequency of Numbers Week Progress Bar

0:46 Sunday, Monday. And we're going to take this all the way down. And we're going to have to turn this into a VLOOKUP . Now this is pretty tough to sort of remember all of this, but it's possible. Totally possible to do. Put the range here, index 2, is it sorted, false. Is it a Wednesday? New Year's Day is actually, yes, a Wednesday. So if we wanted to change this type to 0, let's say, or 2, let's say, it's going to change our need to do a VLOOKUP table . So we want to put that to 1, so that it's 1, 2, 3, 4, through 7, Sunday through Saturday. And now we can change all of these numbers to its corresponding weekday. Switch Data How to Create a Tab For Every Week of the Year

1:34 We do have to probably lock this D2 to E8. There. That works. And is it a Wednesday? Yes, it is. But there's another way to do this that is pretty simple, uh, and I, I like to do this with formatting . So let's delete this and just put literally the day of the week, the date, and we're trying to get the weekday out of it. Let's go to format , let's go to number , scroll down to custom date and time, and here we see up here a drop down menu that shows us what can we. Select out of these numbers. Can we show it in a different way? And we can here we have day as full name, Tuesday as abbreviation, T U E for Tuesday or Tuesday, the full name. What we need to do is delete everything except the day. How to Format Timestamp to Day and Month Week Progress Bar

2:22 So we're going to delete the year and those slashes and just select day. And now we can say day as full name apply. And now the display is. just formatting the date. Now we could potentially just change that date there, but we can also do something else equals this. And now we're referring to just this singular date here and showing the weekday with just this simple formula equals B2 and a formatted cell. And I think this is simpler because we're still using this date, we don't need to change it, and we don't need to use a formula combination like VLOOKUP and weekday. How To Change Date Format Automatically Google Sheets Interface Changes How to Show Month Name, And Not Whole Date, in Google Sheets

3:09 But it is also up to you if you want to, which one you want to use. I just wanted to show you two ways to know the day of the week from any day. Now we can change it any year, any month, any day, and it will show us the weekday. Hopefully that was helpful to you. If you are looking to get more out of your Google sheets than you ever have before, make sure to sign up at better sheets. co become a member for a small price. You get access to hundreds of tutorials, spreadsheets, templates, and tools, including an AI formula generator that is going to help you through some really complicated formulas and any speed bumps you occur when you're using Google sheets. So join us today over at better sheets and Hey, if you haven't subscribed yet, make sure you subscribe here on YouTube. Bye. Google Sheets Interface Changes Google Sheets Interface Changes Now Do It Every Damn Day - Learn to Code in Google Sheets Part 5 Big Year