Calculate date difference

In QuickTable, you can easily calculate the difference between two dates through Date diff operation. You can find it by clicking "Dates & Times" > "Date diff":

In this example, you want to calculate the number of days between the Order date and the Ship date. You just need to configure as follows:

Date diff only supports calculations in Date format . You need to convert the text column to Date first, if necessary.