Calculating the number of days between two dates as a new column

[Yosinator]

It seems I am just getting another date as the output. 

Any ideas? 

[Satya_Bhamidipa]

Click on new column

Add formula : Ex: = Table.AddColumn(#"Changed Type", "Custom", each [to Date] -[#"From Date "])

Change new column type to whole number

[mariussve1 · Accepted solution]

Hi,

Hi,

If you change the data type on your new column to Whole number (int) it should show the number of days betweeen your column 🙂

Br

Marius