# Formulas

Options
edited 12/09/19

I want to create a formula in a cell that subtracts a certain number of days from another cell that is linked to another persons Smartsheet.  How would I do that?  My efforts have failed.

• ✭✭✭✭✭✭
Options

Hi there,

This is pretty simple. After you have linked the cell... you can use simple math to adjust the days. For instance. If you have a linked cell in [Column2] row 3 and want to add 10 days to it. In a new column (set up as a date column) and row, use the following formula. Do note that because you are creating a new date you need to use the Date Column type to make that happen.

=[Column2]3 + 10

If you want it to be 10 days before that date use this formula

=[Column2]3 - 10

If you want it to be 10 working days after the linked cell date and you have set up your working days in your account settings.

=Workday([Column2]3,10)

Or 10 days before.

=Workday([Column2]3,-10)

Hope that helps!

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!