DAYS360 Function in Excel

Home/Excel Formulas/DAYS360 Function in Excel

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

50+ Project Management Templates Pack
Excel PowerPoint Word

Advanced Project Plan & Portfolio Template
Excel Template

Business Presentations Templates Pack
PowerPoint Slides

20+ Excel Project Management Pack
Excel Templates

20+ PowerPoint Project Management Pack
PowerPoint Templates

10+ MS Word Project Management Pack
Word Templates


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
By |May 20th, 2013|Excel Formulas|1 Comment

About the Author:

Excel VBA Developer having around 8 years of experience in using Excel and VBA for automating the daily tasks, reports generation and dashboards preparation. Valli is sharing to helps us automating daily tasks.

One Comment

  1. Sudhakar September 14, 2015 at 7:03 PM - Reply

    thanks

Leave A Comment


Related pages


excel loop functionexcel vba clearcontentsselecting a sheet in vbasimple vbscript examplevisual basic conditional statementscode for comboboxexcel checking for duplicatesvba byvalexcel vba commentworksheetfunctionexcel vba code exampleshow to use sum if formulaunprotect a spreadsheetcell interior color vbaexcel horizontal lookuppublic variable vbaexcel graph tutorialvba worksheet changehow to unlock excel sheetsumifs excel examplevba lookup tablehandy excel macrosproforma of minutes of meetinglearning vba in excelexcel duplicate linessort az excelvba msofiledialogfilepickervba worksheetfunction vlookupbasic macros in excelsample meeting minutes template wordexcel auto enable macrosadd developer tab to ribbon wordexcel vba sortingvlookup formula explainedcreating a dashboard in excel 2007identify duplicate records in excelexcel vba select rowshow to connect excel to sqlexcel vba made easyexcel 2007 dashboardsifs formula excelhow to get data from another worksheet in excelhow to insert a hyperlink in excelunhide worksheetvba protect all sheetsequals vbaif statement vbavlookup fixed rangemicrosoft excel tutorial torrentvba delete rowsvba excel function returnprotect formulas in excel 2007excel delete duplicate valueslistbox in vbmerge a cell in excelvba write to text filelistbox multiselect vbavba serverunprotect excel sheet forgot passwordsimple vlookup formulabreak loop in vbaexcel vba workbook openapplication inputboxtcl commands in sql server with exampleshow to dedup in excelautofit in excel 2007formula for adding columns in excelxls macro programmingexcel macros programmingsas reporting tutorialmatch function in excel 2007sql tutorial advanced with exampleshow to change the width of columns in excelexcel macros buttonvba mod 2provider msdasql