Calculation to calculate the time duration (days) between two dates?

[wholelottared]

Hello all,

Say I have 2 basic dates (Date In, Date Out), what's an expression to calculate the duration of the two dates (preferably in days)

Load * Inline [
Date In,Date Out
02/03/2020,02/05/2020
02/03/2020,02/09/2020
02/03/2020,02/11/2020
02/03/2020,03/03/2020
];

THANKS!

[Taoufiq_Zarra · Accepted solution]

Maye be

Date([Date Out])-Date([Date In])

[Tanalex]

Try this NUM(FLOOR([Date Out]) - FLOOR([Date In]),'#,##0')

You may want different formatting.