I want to calculate difference between two dates in sheets. In apps there is DATEDIF that works. Whats the equivalent in sheet?
Hi,
You can add a new column in your Sheet of type “Formula”. Give an appropriate name to the column. Once the column is created, on the column header, you will see a icon. Click on this icon and write the below formula, click on Save & Validate and then Save; you will get the difference between two dates. -
((date-date1)/86400/1000)
Where date & date1 are two different Date type column.
Hope, this works for you!