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
Answers
-
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
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 430 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 146 Just for fun
- 63 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!