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)

     

     

2 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    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?