# Excel DAYS360 Function: Syntax, Examples & Tips - URL: https://betteranalyst.com/excel/days360-function - Author: Better Analyst Formula Bot is now Better Analyst—same account, more powerful analysis.Formula Bot is now Better Analyst—same account and workflows, with more powerful analysis, dashboards, and automation. [Learn what changed](https://betteranalyst.com/formula-bot-is-now-better-analyst) The DAYS360 function calculates the number of days between two dates based on a 360-day year, with options for different day count conventions. ```excel =DAYS360(start_date, end_date, [method]) ``` Generate FormulaExplain Formula One free generation or explanation per browser, shared across Excel and Google Sheets. Account usage limits apply afterward. Describe the DAYS360 you need in plain EnglishGenerate Formula Need more than a single DAYS360 formula? Try our free [AI for Excel](https://betteranalyst.com/excel-ai) — it reads your entire spreadsheet, answers questions in plain English, and builds charts and analysis in the same chat. ## Parameters **`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). ## What is a DAYS360 Formula in Excel? 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. ## A Practical Example Imagine you are managing a loan repayment schedule, and you have the following data in an Excel spreadsheet: ### Loan Data Table: | 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. ## DAYS360 Formula To calculate the number of days between the start and end dates, you would use the DAYS360 formula as follows: ```excel =DAYS360(A2, B2) ``` ### Breakdown of the Formula: - **A2**: This is the start date of the loan period. - **B2**: This is the end date of the loan period. ## Result of the Formula 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). ## Why Use DAYS360? 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. ## Key Takeaways: - **DAYS360**: Calculates the number of days between two dates based on a 360-day year. - **Standardized Calculations**: Useful for financial analyses that require a consistent day count. - **Common Use Cases**: Ideal for interest calculations, loan repayment schedules, and any scenario where a 360-day year is applicable. 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! ## Example use case 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](https://betteranalyst.com/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](https://betteranalyst.com/excel-ai) 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](https://betteranalyst.com/ai-excel-spreadsheet-generator) to turn a text prompt into a downloadable Excel file — a full [AI Excel sheet maker](https://betteranalyst.com/ai-excel-spreadsheet-generator) that builds headers, columns, and formulas from your description. ## Need more help with Excel formulas? Create a free account for formula help, explanations, and spreadsheet analysis. Usage limits depend on your plan. [Create Free Account](https://betteranalyst.com/signup)[Try Formula Generator](https://betteranalyst.com/excel-ai) ## Excel how-to guides - [How To Password Protect An Excel File](https://betteranalyst.com/excel/how-to-password-protect-an-excel-file) - [How To Remove Blank Rows In Excel](https://betteranalyst.com/excel/how-to-remove-blank-rows-in-excel) - [How To Remove Duplicates In Excel](https://betteranalyst.com/excel/how-to-remove-duplicates-in-excel) - [How To Separate Names In Excel](https://betteranalyst.com/excel/how-to-separate-names-in-excel) - [How To Sort In Excel](https://betteranalyst.com/excel/how-to-sort-in-excel) - [How To Split Cells In Excel](https://betteranalyst.com/excel/how-to-split-cells-in-excel) - [How To Strikethrough In Excel](https://betteranalyst.com/excel/how-to-strikethrough-in-excel) - [How To Subtract In Excel](https://betteranalyst.com/excel/how-to-subtract-in-excel) ## Explore all Excel formulas Browse our complete library of Excel formula guides Compare your options ## Decide with evidence, not a sales pitch. Open a neutral research prompt in the AI tool you already use. Compare capabilities, limitations, and fit before you choose. 1. [01ChatGPTOpen a balanced comparison prompt in ChatGPT.](https://chatgpt.com/?prompt=Compare%20Better%20Analyst%20with%20using%20a%20general-purpose%20AI%20assistant%20for%20data%20analysis.%20Evaluate%20spreadsheet%20and%20document%20analysis%2C%20dashboards%2C%20repeatable%20reports%2C%20code%20transparency%2C%20data%20connections%2C%20pricing%2C%20and%20limitations.%20Use%20current%20public%20sources%2C%20distinguish%20verified%20facts%20from%20assumptions%2C%20and%20explain%20which%20types%20of%20users%20each%20option%20fits%20best.) 2. [02ClaudeOpen the same research prompt in Claude.](https://claude.ai/new?q=Compare%20Better%20Analyst%20with%20using%20a%20general-purpose%20AI%20assistant%20for%20data%20analysis.%20Evaluate%20spreadsheet%20and%20document%20analysis%2C%20dashboards%2C%20repeatable%20reports%2C%20code%20transparency%2C%20data%20connections%2C%20pricing%2C%20and%20limitations.%20Use%20current%20public%20sources%2C%20distinguish%20verified%20facts%20from%20assumptions%2C%20and%20explain%20which%20types%20of%20users%20each%20option%20fits%20best.) 3. [03PerplexityResearch the comparison with linked web sources.](https://www.perplexity.ai/search?q=Compare%20Better%20Analyst%20with%20using%20a%20general-purpose%20AI%20assistant%20for%20data%20analysis.%20Evaluate%20spreadsheet%20and%20document%20analysis%2C%20dashboards%2C%20repeatable%20reports%2C%20code%20transparency%2C%20data%20connections%2C%20pricing%2C%20and%20limitations.%20Use%20current%20public%20sources%2C%20distinguish%20verified%20facts%20from%20assumptions%2C%20and%20explain%20which%20types%20of%20users%20each%20option%20fits%20best.) AI answers can be incomplete. Check source links, current pricing, and product documentation before deciding.