How to calculate differences between dates in Google Sheets?
To find the gap between two dates in Google Sheets, try the DATEDIF formula! It needs three things: the start date, the end date, and what you're counting: D, M, Y, MD, YD, YM.
"Y": the number of whole years between start_date and end_date.
"M": the number of whole months between start_date and end_date.
"D": the number of days between start_date and end_date.
"MD": the number of days between start_date and end_date after subtracting whole months.
"YM": the number of whole months between start_date and end_date after subtracting whole years.
"YD": the number of days between start_date and end_date, assuming start_date and end_date were no more than one year apart.
For instance, let's count days. You can use cell links instead of typing in numbers. And by locking columns, you can quickly copy the formula to find out how long each client has been with us.
For more Google Sheets and Looker Studio tricks, follow me on Instagram and YouTube!
#GoogleSheets #DATEDIFFormula #DateCalculations #SpreadsheetFunctions #DataAnalysis #GoogleSheetsTips #ProductivityHacks #LookerStudioTips