Date formula needed

Options

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

Example:

(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 ✓
    Options

    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!


    Best,

    Heather

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!