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?

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 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. -

((date-date1)/86400/1000)

Where date & date1 are two different Date type column.

Hope, this works for you!

DronaHQ Docs have found a new place!

We have updated and moved our documentation to docs.dronahq.com.
You can continue to ask questions in the community here.