Google excel - calculate difference in days between two dates

In this short article, I would like to share how to count days between two dates in google sheets.

Let's say we have 2 dates:

• 08/20/2020
• 08/28/2020

The difference is quite small, only 8 days.

We can use below formula to calculate difference in days between two dates:

xxxxxxxxxx

=DATEDIF("08/20/2020", "08/28/2020", "d")

To understand the order of parameter in first date: 

"08/20/2020" - "MONTH, DAY, YEAR"

• 08 - MONTH
• 20 - DAY
• 2020 - year

We can take a look at below screenshot, to see how it will look like in practice:

As the result we will get:

This is similar to example 1, but we can also use fields in online excel like this:

xxxxxxxxxx

=DATEDIF(B4, B5, "d")

As the result we will get: