Powered by

AVS Document Editor
This page is available in EnglishFrançaisDeutschItalianoEspañol
AVS Document Editor
Download
AVS Document Editor
Current Version:  4.2.3.302
Release Date:  12/27/2016
File Size:
125.17 MB

DAYS360 Function

The DAYS360 function is one of the date and time functions. Is used to return the number of days between two dates (start-date and end-date) based on a 360-day year using one of the calculation method (US or European).

The DAYS360 function syntax is:

DAYS360(start-date, end-date [,method-flag])

where

start-date and end-date are two dates you wish to calculate the number of days between.

method-flag is an optional logical value: TRUE or FALSE. If it is set to TRUE, the calculation will be performed using the European method, according to which the start and end dates that occur on the 31st of a month become equal to the 30th of the same month.
If it is FALSE or omitted, the calculation will be performed using the US method, according to which if the start date is the last day of a month, it becomes equal to the 30th of the same month. If the end date is the last day of a month and the start date is earlier than the 30th of a month, the end date becomes equal to the 1st of the next month. Otherwise the end date becomes equal to the 30th of the same month.

To apply the DAYS360 function,

  1. select the cell where you wish to display the result,
  2. click the Insert Function Insert Function icon icon situated at the top toolbar,
    or right-click within a selected cell and select the Insert Function option from the menu,
    or click the Function icon icon situated at the formula bar,
  3. select the Date and time function group from the list,
  4. click the DAYS360 function,
  5. enter the required arguments separating them by commas,
  6. press the Enter button.

The result will be displayed in the selected cell.

DAYS360 Function

Download AVS Document Editor Current Version:  4.2.3.302File Size: 125.17 MB

Please note that AVS4YOU programs do not allow you to copy protected material. You may use this software in copying material in which you own the copyright or have obtained permission to copy from the copyright owner.

AVS4YOU is a registered trademark of Online Media Technologies, Ltd., UK. Intel and Core 2 Duo are registered trademarks of Intel Corporation. AMD and Athlon X2 are registered trademarks of Advanced Micro Devices, Inc. Windows 10/8.1/8/7/XP/2003/Vista are registered trademarks of Microsoft Corporation. All other trademarks are the property of their respective owners.