Calculating the delta in days between two date columns

BESP10

Good afternoon,

Is there a formula that calculates the number of days between two date columns?

Date Column Delta Calculation.pdf

Uploaded Feb 2, 2021134.58 KB

BESP10

I actually figured this one out @Seth Morth , but thank you for your help

=SUM([Equipment End Date]@row - [End Date]@row)

Seth Morth

Hello,

I found the answer here: https://community.smartsheet.com/discussion/24701/how-do-i-calculate-the-difference-between-2-dates

Looks like you want =NETDAYS([End Date]#, [Equipment End Date]#) where # is the row #.

You can also use =NETDAYS([End Date]@row, [Equipment End Date]@row)

BESP10

Thanks@Seth Morth but its giving me this error ?

BESP10

I actually figured this one out @Seth Morth , but thank you for your help

=SUM([Equipment End Date]@row - [End Date]@row)

Dheeraj Goyal

Hi @BESP10

I am trying to get delta between two dates but its giving error unless the dates are in date column without any formula. Is there any way to get it where date is being fetched using a formula?

Thanks