Calculate Number of Days Between two Dates

2 Ways to find out the number of days between two dates.

First method is simply subtract the older date from the newer date.


Second method is using the DATEDIF function.

In this example, the older date is in cell C5, and the newer date is in B5. The formula is in D5. The “d” returns the number of full days between the two dates.

Warning: If the Older_date is greater than the Newer_date, the result will be #NUM!.
scroll to top