For business users of Microsoft Excel Free guides and templates
Home >  Excel Help >  Excel Functions >  

Date and time

DAYS360 Function

Calculates the number of days between two dates based on a 360-day year


by Charley Kyd, MBA
Microsoft Excel MVP, 2005-2014
The Father of Spreadsheet Dashboard Reports

Syntax

DAYS360(start_date, end_date, method)

  • start_date, end_date  Required. The two dates between which you want to know the number of days.

  • method  Optional. A logical value that specifies whether to use the US or European method:

    • FALSE or omitted: The US (NASD) method. If the starting date is the last day of a month, it becomes equal to the 30th day of the same month. If the ending date is the last day of a month and the starting date is earlier than the 30th day of a month, the ending date becomes equal to the 1st day of the next month; otherwise the ending date becomes equal to the 30th day of the same month.

    • TRUE: European method. Starting dates and ending dates that occur on the 31st day of a month become equal to the 30th day of the same month.

Applies To

Excel 2003 and above

Examples

xxx

Other ExcelUser Information

xxx

Other Help

 

Charley's SwipeFile charts


Free Excel Dashboards