Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Count days between two dates

Hi,   I want to have a custom column with the sum of the days between two dates.   Who can help me out?   Thanks
Need Help
  • amitchandak's avatar
    amitchandak
    3 years ago

    Anonymous , Datediff , and for business daye networkdays

     

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

     

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

     

     

Rambo92's avatar
Rambo92
Helper I
3 years ago

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?