30 Weeks Out - Formula Question
I have a project that has certain tasks that need to start a specific number of weeks ahead of the project end date. For example, I have 30 weeks out tasks, 29 weeks, out 20 weeks out, etc.
On my project sheet, the END DATE is December 1, 2021. I need a formula that would tell me what the START DATE is for exactly 30 weeks out meaning figure the date in reverse - what is the date 30 weeks behind December 1, 2021? It should be something like April or May.... just can't seem to work the forumula.
hope that makes sense!
Thanks so much!
Help Article Resources
Check out the Formula Handbook template!