Menu
EXCEL DAYS360 FUNCTION
Excel DAYS360 Function Introduction
This function calculates 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 and receipts if your accounting system is based on twelve 30-day months.
Description of Excel DAYS360 Function
Syntax:
=DAYS360 (start_date, end_date, [method])
Parameter list:
- start_date – the start date. Dates should be entered by using the DATE function, or derived from the results of other formulas or functions.
- end_date – the end date.
- method – [optional] the type of day count basis to use. FALSE (default) or omitted is US method, TRUE is European method.
- FALSE (default) or omitted – US method – If the starting date is the last day of a month, it becomes equal to the 30th day of the same month. When the end date is the last day of the month, and the start date is less than 30 days, the end date is set to the 1st month, otherwise the end date is set to the 30th of the next of the same month.
- TRUE – European method. Starting dates and ending dates equal to the 31st of a month are set to the 30th of the same month.
Step By Step Guide of DAYS360 Function
Related Functions
HLOOKUP Function
HLOOKUP Function
Explore NowVLOOKUP Function
VLOOKUP Function
Explore NowINDEX Function
INDEX Function
Explore NowMATCH Function
MATCH Function
Explore NowDATE Function
DATE Function
Explore NowIF Function
IF Function
Explore NowOR Function
OR Function
Explore NowAND Function
AND Function
Explore NowRANK Function
RANK Function
Explore NowSUMIF Function
SUMIF Function
Explore NowXIRR Function
XIRR Function
Explore NowWORKDAYS Function
WORKDAYS Function
Explore Now
