What Day is Labor Day This Year
What Day is Labor Day This Year
I wonder if you're wondering the same thing as me is what day is Labor Day this year or any year. Here's the formula to figure it out because Labor Day is the first Monday of September. Every year it's different. And every year we have to figure it out, right? So if you have like a dashboard or you want to actually just automatically figure this out, here's the formula to do it. But I'm going to walk through this formula right now, step by step. Essentially, we have a few interesting formulas that are going to help us out. One, we have equals today. And that's just today's date. But from this today's date, we can get the year. And if we wrap year around today, we're always going to get whatever year it is. This actually says 7 16 because this has been turned into a date. I'm going to change that to automatic and show you here, 2024. So this allows us to automatically know what year it is no matter what.
Every day it's going to turn over and we're going to get the year. That's really cool because we can say, hey, this is the year of today instead of typing in 2024. Another interesting formula . that we can do, is we can use date, and date allows us to literally type in the year, which is year today, wrapped if we want to do it automatically, the month, that's September, and the day, one. And the return of this is literally that date, but as you can tell, today and year is always going to change, so we're always going to get September 1st here, if we type in this date. Labor Day is the first Monday. So how do we check if this is a Monday? We can use the weekday formula . And weekday, if we use the one option, will return one if it's a Sunday, or
it will return two if it's a Monday. So let's look at some dates here. So I'm going to put the date here and look at a few. So let's look at Number two, and the third, and we'll wrap this with weekday, and that is one weekday around this one, and that's two. Now this is a Sunday, and two is a Monday. So let's say the answer is two. Of any year, the first of September is a two. That means it's a Monday, so we're going to put that in. But let's, let's consider that every year it's going to be a different number . So we need to account for all of these different numbers. I'm going to use the switch formula and just find out what is this weekday of September 1st. And switch allows me, if we can look at the help here, what
I can put in different cases. So you might start thinking, Oh, let's create an, if, if it's Monday, do something, if it's not Monday, do something else, but that only gives you two options switch allows you to have every single option accounted for that. We know we're going to get, cause we're just going to get the number one through seven, one, two, three, four, five, six, or seven. And so in the case of one, if it's a Sunday, we want this date. To be two. Because if the first is a Sunday, then the Labor Day is actually the Monday, the next Monday after. If it's a two, then that is Monday, and we just want that date. So let's end it there for one moment and see if this is correct, because right now it's 2024, and Labor Day is actually on the second.
So let's see if this works out. We're going to format this number as a date. There it is. That's the 2nd of September 2024. That is Labor Day. And if we change this year to 2025 and change this year to 2025 and this year to 2025, we'll see it's the 1st. So in 2025, Labor Day is the 1st of September. So we can undo that. And now we have to account for any other number . So one, we just say it's a second. If it's three, see if it's three, we're going to say it is six days away, I think, yeah, so it will be September 7th, right? So if it, the answer is a three. That means September 1st is a Tuesday. So the next Monday will be Labor Day. And now we just need to delete or iterate this number down one each time.
So if it's a 4, it will be the 6th. If it's a 5, it'll be the 5th. Thank you. If it's a four, it'll be the third. Sorry. Fourth. Oh, sorry. If it's number six, four, five, six, it'll be the fourth. If it's a seven, it'll be the third. Right? So it'll be the next Monday. So all of this allows you to find out this year what day is Labor Day. There you go. So we're having the switch just to review. We have a switch using weekday to know what week, day of the week is September 1st. Then we're saying, let's take into account each of these different operations. Is it, is it the first? Is it two, one, two, three, four? In each case, we're going to get the date that it is the proper date for Labor Day. There you go. So you can always test this out by replacing this year today by just some.
year that you want to test out, but that will automatically roll over each and every year. So you never have to figure out what day is Labor Day ever again. There it is. It's done.