I need an Excel spread sheet that will calculate dates based on number of weeks variable.
So, in cell A I enter a personal task to do.
Then in cell B I would enter "12" which would be 12 weeks.
Then in cell C I would enter a date (Month/Year).
Then cell D-M would show the date (Month/Year) multiplied by the number in cell B.
Using Excel 2007, I have attached a CLOSE sample for what I need. The way the attached file works is by calculating cell B by MONTHS, I need it to calculate WEEKS.