=DAYS360(start_date, end_date, [method])One free generation or explanation per browser, shared across Excel and Google Sheets. Account usage limits apply afterward.
Need more than a single DAYS360 formula? Try our free AI for Excel — it reads your entire spreadsheet, answers questions in plain English, and builds charts and analysis in the same chat.
start_date:
The starting date in the date range for which you want to calculate the number of days.
end_date:
The ending date in the date range for which you want to calculate the number of days.
method:
An optional logical value that specifies the method of calculation. If TRUE, the function uses the European method (30-day months); if FALSE or omitted, it uses the US method (actual days).
The DAYS360 function in Excel is a specialized tool that calculates the number of days between two dates based on a 360-day year, which is commonly used in financial calculations. This function assumes that each month has 30 days, making it particularly useful for calculating interest and other financial metrics.
In simpler terms, the DAYS360 function helps you determine the difference in days between two dates using a standardized method, making it easier to perform financial analyses.
Imagine you are managing a loan repayment schedule, and you have the following data in an Excel spreadsheet:
| Start Date | End Date |
|---|---|
| 01/01/2023 | 01/31/2023 |
| 02/01/2023 | 03/01/2023 |
| 04/15/2023 | 05/15/2023 |
| 06/01/2023 | 06/30/2023 |
| 07/01/2023 | 08/01/2023 |
You want to find the number of days between the start and end dates for each loan period using the 360-day year method.
To calculate the number of days between the start and end dates, you would use the DAYS360 formula as follows:
=DAYS360(A2, B2)When you apply the formula to the first row, it calculates the number of days between January 1, 2023, and January 31, 2023, using the 360-day year method. The output would be:
| Days Between Start and End Date |
|---|
| 30 |
Here, the number of days is calculated as 30 days (January has 30 days in this method).
The DAYS360 function is particularly useful when you need to perform financial calculations that require a standardized day count. It simplifies the process of calculating interest, loan payments, and other financial metrics by using a consistent method.
Understanding how to use the DAYS360 function can significantly enhance your financial analysis capabilities in Excel, enabling you to perform accurate calculations based on standardized methods.
Happy calculating!
You have a table where Column A contains the start dates of various projects and Column B contains their end dates. You can use the DAYS360 function to calculate the number of days each project took based on a 360-day year. This allows for standardized project duration analysis, making it easier to compare project timelines and assess resource allocation without the need for more complex date calculations.
Beyond the DAYS360 function: Better Analyst is a full Excel AI that goes well past individual formulas. Upload any spreadsheet and ask questions in plain English — you'll get formulas, data analysis, and charts back in seconds. It's a free AI Excel assistant that works with any .xlsx, .xls, or .csv file — no plugins, no Microsoft 365 required.
Don't have a spreadsheet yet? Use our free AI spreadsheet generator to turn a text prompt into a downloadable Excel file — a full AI Excel sheet maker that builds headers, columns, and formulas from your description.
Create a free account for formula help, explanations, and spreadsheet analysis. Usage limits depend on your plan.
Browse our complete library of Excel formula guides
Compare your options
Open a neutral research prompt in the AI tool you already use. Compare capabilities, limitations, and fit before you choose.
AI answers can be incomplete. Check source links, current pricing, and product documentation before deciding.