How to use Excel DAYS360 Function

Introduction

DAYS360 function in Excel is a type of DATE/TIME function. It gives value of the number of days falling between two dates by considering a 360 days year. It does so by considering every month of the year to be consisting of 30 days. This function can be applied to find the number of the days from the date present in the cell. This can also be used to extract and put the number of the days into other functions, for example in DATE function.

Syntax

=DAYS360(Start_date,End_date,method)

Arguments

  • End_Date- The end date to which one wants to calculate the number of DAYS360.
  • Start_Date- The start date from which one wants to calculate the number of DAYS360.
  • Method- It is a logical value in form of TRUE or FALSE. FALSE is default value (US system) and TRUE represents European method.

Keynotes

  • In General formatting of Excel, Dates are in form of serial numbers. Serial number 1 is for 1 JAN, 1900 and the number increases from thereon. For getting it in readable form use the formatting tab.
  • The argument used must represent a valid date in Excel format.
  • If the arguments used have number values which are out of range of valid excel date, #NUM error is displayed
  • If the arguments used have strings which cannot be converted into valid dates, #VALUE error is displayed.
  • US method- When Star_Date used as argument is last day of a month, than it is considered as the 30th day of the month. When end_date used as argument is last day of a month, than it is considered as the 1st day of the next month.
  • European method- Whether start_date or end_date is 31st of a month than it is considered as the 30th of the given month.

Examples

  • In this example, dates are given in column A and B, number of DAYS30 between these dates based on 360 day year, are calculated using the DAYS360 function in column C.

Leave a Reply

Close Menu