Excel DAYS360 function

Function              DAYS360

Description        Excel DAYS360 function returns the number of days between two dates based on a 360-day year (twelve 30-day months), which is used in some accounting calculations. Use this function to help compute payments if your accounting system is based on twelve 30-day months.

Syntax  DAYS360(start_date,end_date,method)

start_date It is a Date value in serial number format

end_date It is a Date value in serial number format

method: FALSE – U.S.
(NASD) method [start date and end date will be approximated to 30-day months via this method.]

               TRUE – European Method [Start dates and end dates that occur on the 31st day of a month will be equal to the 30th day of the month.]