How Many Days Has it Been Since My Last Birthday?
Learn how to calculate the number of days since your last birthday using Google Sheets formulas. This video covers the date difference function and how to customize it for any date.
Do you ever wonder how many days has it been since my last birthday or anyone else's birthday? We can see Big Bird had a birthday September 2nd, but we have this year in 1969. If we use date diff, we can have a start date , which will be that birthday, and an end date , which will be today with parentheses. That's a formula that just says, Change that particular day to whatever day is today, and that'll automatically change every single day as the day rolls over. And our unit, if we use d, it's gonna show us that we have 20, 000 days since this date. However, if we use yd, it shows us however many days has passed since that first date, but minus any whole years. So we just get days since the last date. We can see here, if we apply this to all of these dates, it's been How Many Days Between Two Dates? How Many Days Until 4th of July
261 days since Bert's last birthday. If you enjoy this and you want to get more tips, tricks, and how to's, and get more out of your Google Sheets, subscribe here on BetterSheets on YouTube. Get Sheets Wrapped 2024 | Your Year in Google Sheets 80 Years In 1 Spreadsheet Big Year - a Whole Year in One Google Sheets Tab Happy Sheet