Excel DAYS360 Function is a useful tool that helps you calculate the number of days between two dates using a 360-day year, often used in financial and accounting contexts. This function can be especially handy for calculating interest or time periods in financial calculations.
DAYS360(start_date, end_date, [method])
|start_date||The initial date from which you want to calculate the days.|
|end_date||The final date up to which you want to calculate the days.|
|[method]||(Optional) An optional argument that specifies the method to use for day count calculation. If omitted, it defaults to the U.S. (NASD) method.|
start_date: The initial date from which you want to calculate the days.
end_date: The final date up to which you want to calculate the days.
[method] (Optional): An optional argument that specifies the method to use for day count calculation. If omitted, it defaults to the U.S. (NASD) method.
How to use
To use the DAYS360 function, follow these steps:
- Enter the formula in a cell where you want the result to appear.
- Provide the start_date and end_date arguments as cell references or valid date values.
- If needed, add the optional method argument to specify the calculation method.
- Press Enter to get the calculated result.
Here are some examples of how to use the DAYS360 function:
Assuming cell A1 contains the start_date and cell B1 contains the end_date, use this formula to calculate the number of days between these two dates:
If you want to use a different day count method, such as the European method, you can include the optional method argument like this:
=DAYS360(A1, B1, 2)
The method argument can be:
0 (or omitted): U.S. (NASD) method
1: Actual/360 method
2: Actual/365 method
3: European method
It’s important to note that the DAYS360 function calculates days based on a 360-day year, which can be different from the actual number of days between two dates. Be aware of this when using the function in financial calculations.