Just subtract one date from the other. For example if cell A2 has an invoice date in it of 1/1/2015 and cell B2 has a date paid of 1/30/2015, then you could enter use the formula =B2-A2 to get the number of days between the two dates, or 29.
How do I calculate months between two dates in Excel without Datedif?
Using YEARFRAC Function (Get Total Months Between Two Dates) Unlike the DATEDIF function, the YEARFRAC function will give you the values in decimal in case a year has not elapsed between the two dates.
How do I insert a Datedif in Excel?
Using The DateDif Function in Microsoft ExcelHave you ever needed to work out the difference between two dates? There are a couple of ways to insert a function into an Excel Worksheet.This will bring up the Insert Function Window.Search for the Function you want to use, and select go.More items •24 May 2021