Find Number Of Days Between Two Dates In Excel

We have been given two dates and suppose we want to get the number of days between these dates.

Its a common practice and as excel internally store the date as a numeric value, by subtracting two dates will have the same result as subtracting two numeric value.

We could get the number of days simply by subtracting one date from another using a simple subtraction operator.


Insert a formula as below and press enter.


Now you have got the number of days between these two dates.


Hope this helped.

Share The Knowledge

Random Posts

Leave a Reply