Date formula needed


I am trying to write a formula to calculate a date 14 days prior to an entered date.


(entered) Date onsite 8/05/21

(calculated) Allocation date (auto calculate 14 days prior to entered date)

This is based on 7 days a week. Not a work week.

Does anyone have any tips regarding a formula to use?

Best Answer

  • Heather Duff
    Heather Duff ✭✭✭✭✭✭
    Answer ✓

    Hi! Be sure the date column you're working off of is set as a date column, and the column where you're entering the formula is set as a date column as well.

    Here I'm assuming that your Date column is called Date.

    =[date]@row - 14

    Let me know if it works for you!




Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!