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.

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.