1993-1995,1994-1996,1995-1997
i just example it for 3 yrs list you can expand it as requiredThanks INCOMETAX111. Interesting. Its work from 1993-1995 to 1995-1997 but not the next sequence.
I still type long list of year period from 1993-1995 up to current one time then it works.
Mr Singh
In A1, enter formula and copied down :How to repeat sequence if you copy each 3 year time period 5 times?
see example
1993-1995
1993-1995
1993-1995
1993-1995
1993-1995
1994-1996
1994-1996
1994-1996
1994-1996
1994-1996
1995-1997
1995-1997
1995-1997
1995-1997
1995-1997 etc..
Thank you
Mr Singh
Wow. Thank you. Bosco_yip.In A1, enter formula and copied down :
=1993+INT((ROW(A1)-1)/5)&"-"&1995+INT((ROW(A1)-1)/5)
Regards
In A1, formula copied down :Wow. Thank you. Bosco_yip.
Similiar last thing how to repeat sequence if you copy date period 5 times but adding date + 1 after 5 times?
see example
01/01/1993
01/01/1993
01/01/1993
01/01/1993
01/01/1993
01/01/1994
01/01/1994
01/01/1994
01/01/1994
01/01/1994
01/01/1995
01/01/1995
01/01/1995
01/01/1995
01/01/1995 etc.
Thank you.
Mr Singh