Forumla DATEDIF is available in apps but not in sheets. How to find difference (in days) between two date columns?


I want to calculate difference between two dates in sheets. In apps there is DATEDIF that works. Whats the equivalent in sheet?




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 image 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!