Let's calculate days since a timestamp . We have timestamps when we have form submissions. We have timestamps when we add new date with app script to a cell. We have actually two different formulas that can do this for us. and give slightly different answers , meaning one is sort of rounded and one is a very exact number . The very exact number is equals, today, with parentheses, minus whatever cell the timestamp is in. Now if we hit enter and we suggest autofill here, or we copy paste this formula down, we see this is a very specific number. This is 2. 5, 7. 5, 1. 6, 0. 5. But what if we want just like Actually, number of days, not very specific. How Many Days Between Two Dates? Add A Timestamp to Task Lists (without Now Formula) How to Calculate How Many Days in a Year in Google Sheets

We could round this, absolutely. But we could also use a different formula . Let's equals date diff, Our start date is going to be the timestamp , comma, end date is today with parentheses, and our unit is going to be in quotes, the letter D. And let's end parentheses, hit enter, autofill that, or copy paste it, and we have a very rounded number here. Remember this was like 2. 5 something, this was 7. 5, this was 5 down here. We have a round number of number of days since this timestamp. If you're looking to get more out of your Google Sheets, subscribe here on Better Sheets on YouTube. How Many Days Between Two Dates? Google Sheets Interface Changes How to Track Days Since Task Started in Google Sheets