Hi AT Community,
I am writing a formula that will yield a series of workback dates based on a project’s Launch Date. I’ve gotten as far as DATEADD({Launch Date},-7,‘days’) but it does not exclude weekends.
For example, a project which launches on 8/30 (Friday) has a key milestone at -7 business days. The above formula will push out 8/23 (Friday) but should be 8/21 (Wednesday). So, the problem is that my current formula includes Saturday and Sunday in the day count.
My goal is to be able to add a project’s launch date and have a series of workback milestones automatically generate but only take into account WEEKDAYS. Does anyone know of the magical formula?
Thank you!
Jordan
