I am looking for a formula that would allow me to enter an end date for a
project and the number of weeks it would take to complete and these numbers
would automatically populate a 52 week spreadsheet by filling the appropriate
cells with color going back in time to give me a start date. for example if I
had a completion due date of July 17th and it was supposed to take 16 weeks
to complete when would I need to start?