Embedded Files
In Google Sheets, if we need to know how far two different dates are separated from each other, we can make use of the DATEDIF formula. It stands for “Date Difference”. Depending on the specified unit type, the output is in either number of days, months or years.
How to use?
How to use?
SYNTAX: =DATEDIF(start_date, end_date, unit)
start_date - The start date to consider in the calculation. Must be a reference to a cell containing a date, a function returning a date type or a number.
end_date - The end date to consider in the calculation. Must be a reference to a cell containing a date, a function returning a date type or a number.
unit - A string abbreviation for unit of time. For example, "M" for month. Accepted values are "Y","M","D","MD","YM","YD".
PRACTICE SHEET
The above sheet is view only mode, please make a copy to practice.
Page updated
Google Sites
Report abuse