Date formula


I need help with a date formula, I need to enter a date and once enter 10 weeks are subtracted from that date. New date will be displayed. Thank you.

Best Answer

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

    Hi @IDM ,

    Because 10 weeks = 70 days, you should be able to use the following formula:

    =[date column]@row - 70

    Be sure both columns are set to Date within the properties of the column.

    Hope this helps! 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!