Calculating the duration between two dates is a common task in Excel. You can achieve this easily using basic subtraction or the dedicated DAYS function.
Mit KI erledigenPrepare your data
Enter your start date in one cell (e.g., A2) and your end date in another cell (e.g., B2).
Use the subtraction method
In a new cell, type '=B2-A2' and press Enter to see the total number of days.
Use the DAYS function
Alternatively, type '=DAYS(B2, A2)' in a cell and press Enter to calculate the difference.
=DAYS(end_date, start_date)Excel automatically formats cells containing date calculations as dates. Change the cell format to 'General' or 'Number' in the Home tab.