{"id":9994,"date":"2019-10-23T12:42:32","date_gmt":"2019-10-23T10:42:32","guid":{"rendered":"https:\/\/www.myexcelonline.com\/?p=9994"},"modified":"2023-11-30T17:42:10","modified_gmt":"2023-11-30T16:42:10","slug":"days360-formula-in-excel","status":"publish","type":"post","link":"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/days360-formula-in-excel\/","title":{"rendered":"DAYS360 Formula in Excel"},"content":{"rendered":"

 <\/p>\n

What does it do?<\/strong><\/em><\/p>\n

Gets the number of days between two dates using 30-day months<\/p>\n

Formula breakdown:<\/strong><\/em><\/p>\n

=DAYS360(start_date<\/span>, end_date<\/span>, [method]<\/span>)<\/p>\n

What it means:<\/strong><\/em><\/p>\n

=DAYS360(starting date<\/span>, ending date<\/span>, [US or European Method]<\/span>)<\/p>\n

\n

If you need to get the difference of two dates, but want to use 30-day months<\/strong> in calculating the difference, Excel has you covered! We can use the\u00a0DAYS360 Formula\u00a0<\/strong>to do this. It can be useful in the accounting world and there are two modes that are used to count the number of days:<\/p>\n

US Method (Default)<\/strong><\/p>\n

    \n
  • If your start date is the last day of the month, then it is treated as the 30th day of the same month<\/li>\n
  • If your end date is the last day of the month and your start date is earlier than the 30th day of the month, then the end date is treated as the 1st day of the NEXT month, otherwise the end date is treated as the 30th day of the same month<\/li>\n<\/ul>\n

    European Method<\/strong><\/p>\n

      \n
    • If your start date or end date is the 31st day of the month, then it is treated as the 30th day of the same month<\/li>\n<\/ul>\n

      We will be using the Default US Method in our examples below!<\/p>\n

      I explain how you can do this below:<\/p>\n

      \n