Function statement giving me date 4 month before due date.

Hi, I have a column of due dates, I need a column listing a day four months before the due date. This will be my project start date. I was looking at =IF(MONTH>4,[Due Date]@row,

Any help would be appreciated.

To add on to this. I plan to set up an automation to copy rows to another sheet on the week (or day) they are due to start using the new project start date column.

Thank you


  • Genevieve P.
    Genevieve P. Employee Admin

    Hi @Kimbh

    The easiest way to do this would be to subtract a number of days from the Due Date in a Date column, like so:

    =[Due Date]@row - 122

    See: Use Formulas to Perform Calculations With Dates

    This will give you the date 122 days before your Due Date. If the output is in a Date Column, you can then use this column as a trigger in a workflow, see: Create a Time-Based Automated Workflow

    As an alternative, you could use the MONTH function to return the MONTH number from the Due Date column, then subtract 4, but it gets a little more complicated when you cross through years and need to subtract 4 from 1 or 2. Would the Day formula above work for your purposes?



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!