How to show the difference between two dates

Finding out how long between two dates in a Google Spreadsheet is very simple: you just subtract the later one from the earlier one, like this:

Looking in more detail at what happens on the spreadsheet in this formula, you just need to

• Type an equals sign ("=") - this tells the spreadsheet that you are going to put a formula into that cell
• Type (or point to) the later value
• Type a minus sign ("-")
• Type (or point to) the earlier value
• Press Enter

Google Sheets uses colour-coding in the cells and dotted lines to help you see exactly what cells the formula is pointing to.

Was this helpful?   You may also need to read:

• Date-calculations and Plus-One: whole vs partial days
• Calculating the difference between two times
• Google Sheets date-format effects on calculation results