DATEDIF (PQL - xl)

This function returns the number of days, months, or years between two dates

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

Syntax

DATEDIF(start date, end date, unit)

Function Arguments

Name

Description

Type

Optional

start date

Any date

StringOrNumber

end date

Any date

StringOrNumber

unit

Output code

String

Comments

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