Difference between 2 dates – DATEDIF If you want to calculate the difference between 2 dates in Excel, you have to use a hidding function . It's the function DATEDIF.