Function statement giving me date 4 month before due date.

Kimbh

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.

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?

Cheers,

Genevieve