{"id":1298,"date":"2018-07-04T10:13:46","date_gmt":"2018-07-04T10:13:46","guid":{"rendered":"http:\/\/officetuts.net\/excel\/?p=1298"},"modified":"2024-02-05T18:14:07","modified_gmt":"2024-02-05T18:14:07","slug":"days360","status":"publish","type":"post","link":"https:\/\/officetuts.net\/excel\/functions\/days360\/","title":{"rendered":"DAYS360 function"},"content":{"rendered":"\n
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.<\/p>\n\n\n\n
DAYS360(start_date, end_date, [method])<\/strong><\/p>\n\n\n\n start_date:<\/strong> The initial date from which you want to calculate the days.<\/p>\n\n\n\n end_date:<\/strong> The final date up to which you want to calculate the days.<\/p>\n\n\n\n [method] (Optional):<\/strong> An optional argument that specifies the method to use for day count calculation. If omitted, it defaults to the U.S. (NASD) method.<\/p>\n\n\n\n To use the DAYS360 function, follow these steps:<\/p>\n\n\n\n Here are some examples of how to use the DAYS360 function:<\/p>\n\n\n\n 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:<\/p>\n\n\n\n If you want to use a different day count method, such as the European method, you can include the optional method argument like this:<\/p>\n\n\n\n The method argument can be:<\/p>\n\n\n\n 0 (or omitted):<\/strong> U.S. (NASD) method<\/p>\n\n\n\n 1:<\/strong> Actual\/360 method<\/p>\n\n\n\n 2:<\/strong> Actual\/365 method<\/p>\n\n\n\n 3:<\/strong> European method<\/p>\n\n\n\n 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.<\/p>\n","protected":false},"excerpt":{"rendered":" Excel DAYS360 Function is a useful tool that helps you calculate the number of days between two dates using a 360-day year, often…<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[25],"tags":[180],"yoast_head":"\nArguments<\/h2>\n\n\n\n
start_date<\/strong><\/td> The initial date from which you want to calculate the days.<\/td><\/tr> end_date<\/strong><\/td> The final date up to which you want to calculate the days.<\/td><\/tr> [method]<\/strong><\/td> (Optional) An optional argument that specifies the method to use for day count calculation. If omitted, it defaults to the U.S. (NASD) method.<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n How to use<\/h2>\n\n\n\n
\n
=DAYS360(A1, B1)<\/code><\/pre>\n\n\n\n
=DAYS360(A1, B1, 2)<\/code><\/pre>\n\n\n\n
Additional Information:<\/h2>\n\n\n\n