Count days between two dates

[Anonymous]

Hi,

I want to have a custom column with the sum of the days between two dates.

Who can help me out?

Thanks

[Rambo92]

Hi @Anonymous

Go to Add Column> Custom Column.

and deduct the date2 - date1 as shown below. This should probably give you the difference between those dates.

Is this what you are looking for?

[amitchandak · Accepted solution]

@Anonymous , Datediff , and for business daye networkdays

new column = datediff([date1], [Date2], day)

New column business days = networkdays([Date1], [Date2],1)