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.
How to calculate days between two dates
How to calculate number of days between two dates
Calculate difference between two dates
Category: Math and trigonometry
Rounds a number down to the nearest integer
Create a new account
I already have an account
You haven't saved the current formula!
Are you sure to continue?
You haven't save the current formula!
Made with in Istanbul
START LEARNING EXCEL with SHEETZOOM