Poradnik Excela

How to Calculate the Number of Days Between Two Dates in Excel

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.

Zrób to z SI

Krok po kroku

1
Prepare your data
Enter your start date in one cell (e.g., A2) and your end date in another cell (e.g., B2).
2
Use the subtraction method
In a new cell, type '=B2-A2' and press Enter to see the total number of days.
3
Use the DAYS function
Alternatively, type '=DAYS(B2, A2)' in a cell and press Enter to calculate the difference.

=DAYS(end_date, start_date)

Wskazówki

Ensure your cells are formatted as 'General' or 'Number' if the result looks like a date.

Najczęstsze pytania

Why does my result look like a date instead of a number?

Excel automatically formats cells containing date calculations as dates. Change the cell format to 'General' or 'Number' in the Home tab.