DAYS360 (PQL - xl)

This function returns the number of days between two dates based on a 360-day year

  • Library: PQL \ Spreadsheet \ Date & Time
  • Compatibility: Any content (regardless of data source) in the Tabulate spreadsheet module

Syntax

DAYS360(start date, end date, OPTIONAL method)

Function Arguments

Name

Description

Type

Optional

start date

Date from which to calculate days

StringOrNumber

end date

Date to which to calculate days

StringOrNumber

method

Method for calculating days; if FALSE or omitted, uses U.S. (NASD) method; if TRUE, uses European method

StringOrNumber

Y

Comments

This function is the same as the Microsoft Excel 'DAYS360' function - using the same inputs, logic and outputs.