Establishing Automatic Due Dates
I have a project that has a launch date of July 2, which is represented in a column. I would like to have a due date be automatically calculated 63 days prior to this date, in another column. I have created a formula that appears to work, in principle, but rather than setting the date 66 days prior to the July 2 (April 27), it is setting it 96 days prior (March 27). I've never done this before, so any help would be greatly appreciated! Here is my formula.
=WORKDAY([Devotion Date]1, -63)
Help Article Resources
Check out the Formula Handbook template!