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.
Help Article Resources
Check out the Formula Handbook template!