Formula : Date & Time Column

Laura
Laura ✭✭✭✭✭✭

Can anyone assist me with a formula to show

Column 1 - Column 2 = Column 3? Sounds easy enough but the Date/Time column is throwing me off. This is an existing sheet so they don't want me to change the formatting on Column 1 or 2 if possible.

Column 1 : Created Date (Date & Time)

Column 2 : Modification Date (Date & Time)

Column 3 : Overall Days (Number of Days)

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!