Counting days between dates

[vanjak]

Hi,

I have a table with a period begin date and end date 

Period start	Period end
01.01.2021	17.01.2021
15.08.2020	25.07.2021
01.12.2021	14.12.2021

I need a way to measure how many of those days are in between two fixed dates.

For example how many days are between 01.01.2021 and 10.01.2021

The answer in this case, by rows, would be 10, 10, 0.

The period-end/start can have multiple years in between and the same goes for the fixed dates.

[cmcclellan]

Use the DateTimeDiff function - it takes 3 arguments, the start date, the end date, and the units you want to count (ie days, months, etc,)

[Qiu]

@vanjak 
Just a sample.