Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Indentify Shift number in 24 hour period | Excel Worksheet Functions | |||
Performance | Excel Discussion (Misc queries) | |||
Period of Performance calculations | Excel Worksheet Functions | |||
Performance IF(IF or IF(AND | Excel Worksheet Functions | |||
Period to Period percentage change? | Excel Discussion (Misc queries) |