[dedestan]

I'm wondering if it's possible to create dates for milestones as formulas.

We have quarterly production cycles where certain milestones are always a certain number of days from major milestones, but don't actually have durations that we track, and I'd prefer to see them as milestones and not task bars on the gantt.

For example, a major milestone might be the date the PO is placed at the factory (D[Day]). Two weeks prior to that we place orders from secondary suppliers (D-2W). One week after that we place an order for printed materials (D+1W). Sixteen weeks after the order is placed, the order ships (D+16W).

As these are set formulas for each quarterly production run, I'd like to set these as a template, and then each time I'd be able to put in a date for D, and everything would autofill based on the pre-set formulas.

Any ideas?

Thanks.