In this tutorial, we will teach you how to calculate date difference by year, month or day in Excel. In this step by step guide, we will teach you two date functions. The first one calculates the time elapsed and the second one allows you to find a specific day of the week. Such functions are very useful when calculating date differences.