How Many Days Until Christmas

0:00 How many days till Christmas? It's not three days till Christmas. It's actually December 12th when we're recording this. And I want to figure out how many days until the next Christmas. And I want to do this automatically. I don't want to be typing in a number every single day on a little countdown to days till Christmas. How do we do that automatically? I'm going to show you how to do that . So we're going to do equal sign. Date diff. I used to think of this. It's the same formula as dated if, but it's actually date diff, it's the difference between two dates. Start date is going to be today, and we're going to put that as a formula . So that will automatically change all, every single day. Our end date will be date, and the year 2025, and the month is going to be 12, and the day is going to be 25, because that's Christmas. Now, the units, we're going to do comma unit, and use a comma D. Now, actually, this is 2025, so 2024 is 13. How Many Days Between Two Dates? How Many Days Until New Year's Day

0:45 And if we ended here, it would end up giving us an error after this Christmas. So, this year needs to change if there's an error , essentially. Because the only time we're going to have an error out of this is if today is after this date. So What we will do is actually change 2024. We're going to change this to year and wrap that around today. So now this is always this year, but if there's an error , I want to do something else, so we're going to wrap this with if error , and if there's an error , I'm actually just pasting the whole thing here. So it's the exact same formula, except we're going to change today. I, the year to plus one. Actually, so outside of the year brackets, or parentheses, sorry, we're Building a Year Progress Clone How Many Days Until 4th of July

1:30 gonna add plus one, so it'll add one. So what's gonna happen is, it will try to do this data , date diff first. If it gets you a number , great. If it doesn't get you a number , it'll try this one now. You can see actually it gives us 378, but that's not, The next Christmas. The next Christmas is the one that's this year. So essentially, once this today becomes the day after Christmas, it'll revert to this second number . If you're looking to get more out of your Google sheets than you ever have before, consider becoming a member of better sheets. You have 500 tutorials, a dozen courses, courses that help you integrate AI into your sheets. Also how to automate your sheets. I teach you every step of the way from coding Apps Script . It's not as scary as it think, if you know how to do math, you know how to code and it's, there's just like so much awesome stuff at better sheets. com. If you're watching this at the end of the year, get my calendar. Get Sheets Wrapped 2024 | Your Year in Google Sheets Google Sheets Interface Changes How Many Days Until New Year's Day

2:17 Actually in 2024. Now I just created a new calendar called big year . It's an entire year on one tab and you can print it out as a PDF and get it printed and downloadable. It's really awesome. Go check it out. Big year over at better sheets. co. Bye. Big Year - a Whole Year in One Google Sheets Tab Brutal Calendar Craigslist Edition 2023 Big Year - a Whole Year in One Google Sheets Tab Code Big Year - Yearly Planner