Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Mathemathical Operations on Dates/Date Columns
Options
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.
Tags:
Comments
-
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
-
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!
This discussion has been closed.
