Work-back date calculation in proj mgmt template?
I have a large-scale event we run 2x/year, and the scheduling works best as a work-back based on the event date (since there is no extending the delivery date). I want to set up a template so that the start and end dates are are set basically as calculation: [event date cell]-180 (so 180 days before the event date).
My template isn't accepting a date calculation in the start date column. What is the best way to accomplish this, so every time we use the template, all we have to do is change the event date, and everything else will magically be updated?