What is the use of DAYS360 function?

Returns the number of days between two dates based on a 360 day year.

PREMIUM TEMPLATES LIMITED TIME OFFER

ON SALE80% OFF

BROWSE ALL TEMPLATES

50+ Project Management Templates Pack
Excel PowerPoint Word

VIEW DETAILS

Advanced Project Plan & Portfolio Template
Excel Template

VIEW DETAILS

Ultimate Project Management Template
Excel Template

VIEW DETAILS

20+ Excel Project Management Pack
Excel Templates

VIEW DETAILS

20+ PowerPoint Project Management Pack
PowerPoint Templates

VIEW DETAILS

10+ MS Word Project Management Pack
Word Templates

VIEW DETAILS


Note: If start_date occurs after end_date, output gives negative value.

What is the syntax of DAYS360 function?

DAYS360 Function in Excel - syntax

DAYS360(start_date,end_date,method)

Where
start_date & end_date: These two are the dates between which you want to know the number of dates.
method: It is a logical Value specifies whether to use the U.S.(=False) or European(=True) method in the calculation.

DAYS360 Function in Excel – Examples

DAYS360 Function in Excel - Examples

Reference:

Please refer the below article for more Date & Time Excel functions.
Date & Time Excel Formulas

Please refer the below article for more Excel Functions.
Excel Formulas | Home

LIMITED TIME OFFER - Get it Now!
Advanced Project Plan Excel Template

 
Related Resource External VBA Reference