0

The formula uses the fact the MS Excel considers dates as simple numbers starting from 1st Jan 1900. Thus the difference between two dates gives the number of days.

122

How to calculate days between two dates

49

How to calculate number of days between two dates

64

Calculate difference between two dates

Category: Math and trigonometry

Rounds a number down to the nearest integer

INT(number)

Create a new account

I already have an account

By signing in/up, you agree to the Terms of Use and Privacy Policy.

You haven't saved the current formula!

Are you sure to continue?

You haven't save the current formula!

0

The formula uses the fact the MS Excel considers dates as simple numbers starting from 1st Jan 1900. Thus the difference between two dates gives the number of days.