Adding 1 year's difference to user's input of yyyy-yyyy?

[StargateFanFromWork]

If a user inputs 2000-2001, or 2007-2008, is there a way to formulaically
have the cell underneath increase by one year?

i.e., if in B2 the user input, say, 2005-2006, B3 would show 2006-2007 and
B4 would show 2007-2008, etc. down the column?

Thank you! D

 

[Pete_UK]

Try this:

=IF(B2="","",VALUE(LEFT(B2,4))+1 &"-"& VALUE(RIGHT(B2,4))+1)

and copy down the column for as many as you need.

Hope this helps.

Pete

 

[StargateFanFromWork]

Try this:

=IF(B2="","",VALUE(LEFT(B2,4))+1 &"-"& VALUE(RIGHT(B2,4))+1)

and copy down the column for as many as you need.

Hope this helps.

Pete

Seems to do the job just perfectly. Thanks!

 

[Pete_UK]

You're welcome - thanks for taking the trouble to feed back.

Pete