Dates slippage in Excel

[charlie99]

I need to serious help Excel gurus out there!!!

if I have some budgeted production for years 2008 to 2015 each with a figure for each year , for example 2008 = 6.2 , 2009 = 8.5 , 2010 = 12.5 , how do i write some kind of formula if the production year slips , for example 2008 production slips to 2009 , so 2009 = 6.2 , 2010 = 8.5 etc etc

It may be an IF statement involving the date.....I think??

any help will be greatly appreciated.......


cheers gurus

 

[DonkeyOte]

charlie99, not sure I follow... are you wanting to overwrite the year values with revised years ?

Given it's a budget I'm presuming you won't have prior actuals listed in which case I'd be inclined to have a "master" year cell (say A1) and a slippage (say B1).

Assume A1 = 2008, B1 = 0 (no slippage years)

For first year listing in the budget (say in cell A5) I'd have

=A1+B1

For subsequent years (A6 onwards) I'd just use

=A5+1

If at a later date you wanted to add slippage you'd just change B1 to = slippage years.
So assuming B1 = 1 then it follows A5 would become 2009 (2008 + 1), subsequent years would then increment in line with A5.

If this is not your intention could you provide a sample of your "before slippage" layout and then in turn an "after slippage" layout so we can assist further ?