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

#1

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

0 Likes

#2

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!

0 Likes