Happy New Year! I was scrolling through Facebook when Maria O pointed out that 2023 is 7*17^2. That seems interesting. Are there other times in our lifetime that the year is N*NN*^N?
It last happened in 2020. We have a run of them, coming up:
2023: 7*17^2
2025: 9*15^2
2028: 3*26^2
But even cooler is 2025, which is the perfect square of 45^2. Unless you were alive in 1936 or will be alive in 2116, the square year of 2025 will be the only square in our lifetimes.
It last happened in 2020. We have a run of them, coming up:
2023: 7*17^2
2025: 9*15^2
2028: 3*26^2
But even cooler is 2025, which is the perfect square of 45^2. Unless you were alive in 1936 or will be alive in 2116, the square year of 2025 will be the only square in our lifetimes.
Transcript of the video:
Happy seven times 17 squared.
Well, it's New Year's Day and I was scrolling through Facebook and my friend Maria had this great formula.
Seven times 17 squared, and I did the math and sure enough it's 2023.
Happy New Year. And I started wondering, that seems like a really nice compact formula, has this happened before, seven times 17 squared?
So I came here and figured I'd use Excel to try and answer this.
So we'll just build 46 numbers down the left-hand side.
For B, I want to raise it to two right now.
And then across the top, let's see, I want another SEQUENCE.
This time I wanted to go sideways.
So one row, nine columns, and we get the one numbers one through nine.
Then of course, this is a simple little formula here, equal the number to the left of us.
I'll press F4 one, two, three times to lock that column down.
Raise to the number immediately to the left of us, press F4 three times again to lock the column down.
And then multiply that by the number directly above us.
And this time, I'll press F4 twice to lock just the row down.
Copy that across, double click to copy that down.
And just to find them quickly here under Conditional Formatting, New Rule, we're going to use Only Cells That Contain.
And I'm just going to say they're between 1950, that's before I was born, up to 2050, that'll be after I'm dead.
Format.
And we'll just use an orange there.
Click okay, click okay.
All right.
So it's interesting, they're not sorted of course, but 2000 appears to be the last time, 2023, and then we're going to have a run of them here, 2023, 2025, and 2028.
And then there'll be a big gap out to 2048 before that pattern happens again.
Although this one right here, that's pretty amazing, we're just two years from today.
We'll be celebrating a year at least for the first time in most of our lifetimes, that is a perfect square, 45 square.
So 2025, we should plan some big “Square” parties for two years from now.
So consider this podcast your two-year wake-up call to make your plans for 2025.
Here's all the answers that follow this n times n squared.
So 2020, 2023, 2025, 2028, 2048.
And actually when you change that, the exponent from two to others, there's a lot of 2048s that come up because it's a perfect 1024 times two.
So there's all kinds of items there.
Will I make it that far?
That's a good question.
I don't know.
Yeah, maybe that's our goal to have to make it out to 2048.
All right, so there you go.
2023 is seven times 17 squared.
Thanks to Maria for pointing that out.
Look forward to 2025 when we have a perfect square year like that.
All right, thanks to Maria for figuring out that great formula, and thanks to you for stopping by.
We'll see you next time for another net cast from MrExcel.
Well, it's New Year's Day and I was scrolling through Facebook and my friend Maria had this great formula.
Seven times 17 squared, and I did the math and sure enough it's 2023.
Happy New Year. And I started wondering, that seems like a really nice compact formula, has this happened before, seven times 17 squared?
So I came here and figured I'd use Excel to try and answer this.
So we'll just build 46 numbers down the left-hand side.
For B, I want to raise it to two right now.
And then across the top, let's see, I want another SEQUENCE.
This time I wanted to go sideways.
So one row, nine columns, and we get the one numbers one through nine.
Then of course, this is a simple little formula here, equal the number to the left of us.
I'll press F4 one, two, three times to lock that column down.
Raise to the number immediately to the left of us, press F4 three times again to lock the column down.
And then multiply that by the number directly above us.
And this time, I'll press F4 twice to lock just the row down.
Copy that across, double click to copy that down.
And just to find them quickly here under Conditional Formatting, New Rule, we're going to use Only Cells That Contain.
And I'm just going to say they're between 1950, that's before I was born, up to 2050, that'll be after I'm dead.
Format.
And we'll just use an orange there.
Click okay, click okay.
All right.
So it's interesting, they're not sorted of course, but 2000 appears to be the last time, 2023, and then we're going to have a run of them here, 2023, 2025, and 2028.
And then there'll be a big gap out to 2048 before that pattern happens again.
Although this one right here, that's pretty amazing, we're just two years from today.
We'll be celebrating a year at least for the first time in most of our lifetimes, that is a perfect square, 45 square.
So 2025, we should plan some big “Square” parties for two years from now.
So consider this podcast your two-year wake-up call to make your plans for 2025.
Here's all the answers that follow this n times n squared.
So 2020, 2023, 2025, 2028, 2048.
And actually when you change that, the exponent from two to others, there's a lot of 2048s that come up because it's a perfect 1024 times two.
So there's all kinds of items there.
Will I make it that far?
That's a good question.
I don't know.
Yeah, maybe that's our goal to have to make it out to 2048.
All right, so there you go.
2023 is seven times 17 squared.
Thanks to Maria for pointing that out.
Look forward to 2025 when we have a perfect square year like that.
All right, thanks to Maria for figuring out that great formula, and thanks to you for stopping by.
We'll see you next time for another net cast from MrExcel.
