Welcome toTNW Basics, a collection of tips, guides, and advice on how to easily get the most out of your gadgets, apps, and other stuff.
There are a lot of ways to calculate the number of days between two dates. You could use free online calculators. You could do it programmatically, with coding languages, if it’s needed for a product you’re building. But if you want a solution somewhere in between where you’re not required to code, but do wish to feel some ‘wizardly’ gratification, there’s always good ‘ol Excel or Google Sheets.
Now, you could use such a formula in many different ways, for many different purposes. You could, for instance, use it to track how long a certain work project has been running. For this example, we’re going to be using a personal project though: your life in its totality.
Head over to Google Sheets and do the following:
Calling all Scaleup founders! Join the Soonicorn Summit on November 28 in Amsterdam.
Meet with the leaders of Picnic, Miro, Carbon Equity and more during this exclusive event dedicated to Scaleup Founders!
There you go, it’s that simple to calculate the number of days between two dates. Feel free to use this in any other way, for any other purpose.
Story byYaron Yitzhak
Yaron is a Data Analyst & Audience Developer at TNW. He also enjoys writing stories on the intersection of finance and technology, and e(show all)Yaron is a Data Analyst & Audience Developer at TNW. He also enjoys writing stories on the intersection of finance and technology, and explainers on how to work with data even if you don’t have advanced technical skills.
Get the TNW newsletter
Get the most important tech news in your inbox each week.