Trying to figure out how long it took to complete a task?
Use =DATEDIF(start_date, end_date, time_unit) calculate the amount of days, months, or years between two dates.
Different values you can use for `time_unit`
- "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
Common Use Cases
- Get a TTFR (Time to First Reply) metric for your customer support team
- Figure out which part of your process needs optimizing
- Calculating an "average" time to completion for your tasks
