Calculating the delta in days between two date columns
Good afternoon,
Is there a formula that calculates the number of days between two date columns?
Best Answer
-
I actually figured this one out @Seth Morth , but thank you for your help
=SUM([Equipment End Date]@row - [End Date]@row)
Answers
-
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)
-
Thanks@Seth Morth but its giving me this error ?
-
I actually figured this one out @Seth Morth , but thank you for your help
=SUM([Equipment End Date]@row - [End Date]@row)
-
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
Help Article Resources
Categories
Check out the Formula Handbook template!