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 project plan timeline templatesort command in excelddl dml dcl tclexcel vba usernameoutlook meeting minutes templateexcel msgbox yes noexcel remove headerunlock vba codesql aptitude questions with answers pdfdefinition of row in excelexcel how to make a pivot tablevba connect to oracleswot excel templatehow to fix a column in excelnested if vbahow unprotect excel sheetexcel carriage returnmicrosoft office project plan templatemeeting schedule template excelvba dynamic arraymultiple criteria excelexcel action item templateexcel macro codingsas basics tutorialsumif excellvba excel delete sheetvba range sortexcel macro recordingexcel deleting duplicate rowswhat is pivot chart in excelexcel vba bordersrow height in excel 2010project management spreadsheet excel templateproject charter powerpointvba conditionsexcel vba array functionsexcel activeworkbook.saveasvba vlookupexcel vba seriesexcel combo box propertieshow to create stock chart in excelcut and paste worksheetvba global variablerun query from vbavba for pivot tablesexcel visual basic for loopactivex checkboxvb calculator source codeexcel vba lefthow to unprotect excel sheet 2010vb6 check if file existsexcel copy macrobasic excel worksheetexcel macro save as xlsxhow to hide excel sheet with passwordms access convert macro to vbacommand button vba excelvba userform excelexcel call function from cellvlookup excel tutorialexcel vba data typesvba delete filesexcel project trackerexcel userform databaseexcel worksheet headerexcel vba dashboardwhere is the pivot table in excel 2010macros programming in excelexcel vba recordset getrowsexcel vba and macrosdata mining viva questions and answersvb code to connect to sql databaseunlock cells excelmicrosoft excel hyperlinkvba oraclevba password codepivot table advanceform vbacombine tabs in excelvlookup in excel 2007microsoft excel offset function