In this post you will learn how to calculate the number of days between two dates in excel.
Calculating the number of days between two dates –
One of the most common date calculations performed in the corporate world is figuring the
number of days between two dates. Project management teams use it to measure perfor-
mance against a milestone, HR departments use it to measure time to fill a requisition, and
finance departments use it to track receivables aging. Luckily, it’s one of the easiest calcu-
lations to perform thanks to the handy DATEDIF function.
Figure below demonstrates a sample report that uses the DATEDIF function to calculate the
number of days outstanding for a set of invoices.
Looking at Figure, you’ll see the formula in cell D4 is as follows:
=DATEDIF(C4,TODAY(),"d")This formula uses the DATEDIF function with the time code d. This tells Excel to return
the number of days based on the start date (C4) and the end date (TODAY).