The DAYS360 function in Excel returns the number of days between two dates based on a 360-day year (12 x 30 months). Calculations based on a 360-day year comes for certain accounting Reasons where all 12 months are considered to have 30 days.

**Syntax for DAYS360 Function in Excel**

DAYS360( start_date, end_date, [method] )

** **

start_date | The start of the period. |

end_date | The end of the period. |

[method] | An optional logical argument, which gives the method to be used in the calculation. IF FALSE US Method is used, IF TRUE European Method is used |

** **

**Example of DAYS360 Function in Excel:**

**Formula:**

**Results**

- Row number 2 calculates Difference between Jan-1-2017 to Feb-1-2017 which actually 31 days but Because of DAYS360 Function we get 30 days
- Start Date has to be less than end date or else it will result in negative vale which -30 days in row number 3.
- If Start Date and End Date are same then difference between two days will be 0 days Which is shown in row number 4
- Row number 5 calculates difference between Feb-1-2015 to Feb-1-2017, which are Actually 731 days, Because of DAYS360 Function we get 720 days

**Note on Errors of DAYS360 Function in Excel:**

**#NUM!**– Occurs if one or both of the supplied end_date and start_date arguments are numeric values, but are not recognized as valid dates.**#VALUE!**– Occurs if one or both of the supplied start_date and end_date arguments are text values that cannot be interpreted as dates**#VALUE! –**Also occurs when Supplied [Method] Argument is non Logical or non-Numeric.