I want to calculate difference between two dates in sheets. In apps there is DATEDIF that works. Whats the equivalent in sheet?
Forumla DATEDIF is available in apps but not in sheets. How to find difference (in days) between two date columns?
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. -
Where date & date1 are two different Date type column.
Hope, this works for you!