Mathemathical Operations on Dates/Date Columns

Piotr Pulawski

Hi,

is it possible to perform mathemathical operations on dates/date columns in Smartsheet.

Specifically, can I "deduct" one date from another or somehow calculate the difference (in days) between the two?

Thank you.

Find more posts tagged with

Formulas

Comments

Greg Gates

Yep! Addition and subtraction work on date values! If you wanted to find the number of days between two dates for example, try:

=[Date Column1]1 - [Date Column2]1

Piotr Pulawski

Hi Greg, thanks for your help! I tried that and it didn't work for me at first, but then I played around with the settings of the relevant columns and it now works fine.

Thanks again!