ExcelBanter - Shift in Period of Performance

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Shift in Period of Performance (https://www.excelbanter.com/excel-worksheet-functions/211773-shift-period-performance.html)

Shift in Period of Performance

I have a spreadsheet that distributes hours between departments and across
the period of performance. Is there an easy way to make the hours shift if
the period of performance changes so I don't have to manually make the
change, i.e. the original start date is 01/01/2009 (9 months to complete) and
now it has shifted to 04/01/2009, but still 9 months to complete.

Example:

01/09 02/09 03/09, etc.
100 5 5 5
101 5 5 5
102 5 5 5
103 5 5 5

Any help with a formula would be great!! Thanks.

Shift in Period of Performance

Assume that the start date is in cell B1 then in cell C1 enter
=DATE(YEAR(B1),MONTH(B1)+1,DAY(B1)) then copy across to cell J1.

"BUD1888" wrote:

I have a spreadsheet that distributes hours between departments and across
the period of performance. Is there an easy way to make the hours shift if
the period of performance changes so I don't have to manually make the
change, i.e. the original start date is 01/01/2009 (9 months to complete) and
now it has shifted to 04/01/2009, but still 9 months to complete.

Example:

01/09 02/09 03/09, etc.
100 5 5 5
101 5 5 5
102 5 5 5
103 5 5 5

Any help with a formula would be great!! Thanks.