DAYS360 Excel Formula
Excel Date and Time Functions are pre-installed in Excel to help in working with dates and time. The function will also help you understand dates, times which are installed in Excel, and use it in data storage. However, some of the new functions are not available in the earlier versions of Excel.
One of the Excel Date and Time Function is DAYS 360 function, it return the numbers of day between 2 dates which is base on 360 days per year within the 12 months. This function is also helpful in calculating payments basing on the 12 months and 30 days. Syntax for this function includes:
=DAYS360(start_date,end_date,method)
…wherein the argument Start_date, end_date refers to two dates that you like to learn the days in between. The DAYS360 value will turn into negative if the Start_date argument happens right after the end_date argument.
The Method argument refers to the FALSE or TRUE argument. The FALSE argument refers toU.S methods that if the argument start_date is last days of the given month then it will becomes equal in similar month which is 30. And if the end_date argument is the lasts month-day and the start_date is not later that the 30th ending date will be the first day of next month. For the TRUE argument, it refers toEuropean method wherein the start_date argument and the end_date argument that happens on 31st of its month it will automatically be equals to 30th of given month.
Take heed that in Excel dates are stored in sequential serial number so that it could be used for calculations.
As an example, open an Excel worksheet or spreadsheet and input the date 1/30/2008 in cell A2 and the date 2/1/2008 in cell A3. Input the formula as =DAYS360 (A2, A3) and the result will be 1. This means that difference between the given two dates 1 which is based in the 360 days per year.
If you like to view, again the formula of your results then hit the Ctrl+` (grave accent) keys. In addition, you can do this by selecting the Formulas tab, in it select the Formula Auditing group, and hit the Show Formulas option.
Further readings
Post comment
Categories
Recent Posts
- How to Use the MS Excel Keyboard Shortcuts
- How to Locate Duplicate Records Quickly By Using Conditional Formatting in MS Excel
- How to Use PasteSpecial – Procedures for Microsoft Excel 2003 and Microsoft Excel 2007
- How to Sort using an AutoFilter – Understanding and Learning the Feature
- How to Base a Chart Off of Auto Filtered Records
- How to Use IF IsError Together?
- How to Use Custom Views
- How to Create Pivt Table
- How to Manipulate PivotTable after It has Been Created
- How to Update the Data in a Pivot Table
- How to Create Dynamic Named Ranges
- How to Use an Array
- How to Embed 8 If Statements into 1
- How to Edit a Recorded Macro?
- How to Record a Macro
Random Posts
- PHONETICS Excel Formula
- How To Creating New Excel Workbook And Storing It To A Network Drive as A Macro Enabled Workbook
- CHITEST Excel Formula
- STDEVPA Excel Formula
- WEEKNUM Excel Formula
- IMDIV Excel Formula
- STANDARDIZE Excel Formula
- DAYS360 Excel Formula
- TBILLEQ Excel Formula
- How to Edit a Recorded Macro?