Increase years by 1 based on selection

[Monty]

Hello Team.

Actually am trying to increase year by 1 based on the selection of years

Example

Assesment year 2001-2002
Periods 5



So assume that i have in B1 Cell 2001-2002 when i select b2 3

i wanted to display in C1, C2 and C3

as

2002-2003 2003-2004 2004-2005

Test file attatched for your references

 

[Khalid NGO]

Hi,

Your description is not clear to me, see if the attached file helps.

Regards,

 

[trprasad78]

I am not sure my understanding is right.

if we select No. of years, years has to increase from the base year.

Kindly check attached file.

 

[NARAYANK991]

Hi ,

One more !

Narayan

 

[bosco_yip]

Or,

1] In B11, enter :

=0+SUBSTITUTE(B2,"-","")

and >> Custom Cell Format >> 0000-0000

2] In C11, copy across :

=IF(COLUMN(A1)<$B3,B11+10001,"")

and >> Custom Cell Format >> 0000-0000

Regards
Bosco