Days 360 Function

  • It returns number of dates between two dates
  • This function having 3 functional arguments as mentioned below
  • Functional Arguments of DAYS360:

  • Start_date: Indicates about start date of function
  • End_date: Indicates about End date of function
  • Method:

  • (i)This is optional
  • (ii)We need to mention either TRUE or FALSE
  • (ii)If We mentioned TRUE:Result generates based on EUROPEAN method
  • (iii)If We mentioned FLASE:Result generates based on US method
  • (iV)If We omitted it calculates based on US method
  • Function Argument:

    Example:

    Download The Workbook

     

    Days 360 Function

    Download The Workbook Copy