Turn Date into numeric value

Dan Palle
Dan Palle ✭✭
edited 12/09/19 in Formulas and Functions

I would like to follow a task and see the difference between when it was planned and actually done.


To be more precise.

Column "Agreed Date" is used on what date the two parties agreed to finish the task

Colum "Final Date" should show what day the task was really done. This should not change based on date, but should be a numeric value (or similar)

Delta should show, what was the difference between final and agreed date.

Is there an easy approach to this? 

I have a total blackout on how to solve this I think pretty easy topic. THANKS




Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!