Function for Listing of years in two digits

Anybody help me in this

I have attached an example file

I have 98 in C3 and 02 in D3 i want E3 to display like 98,99,00,01,02 (as two digit range of years with both 98(lower limit) and 02(upper limit included...)

Is there any formula to do this or macros?

netvasi,

Attached is a modified version of your sample workbook. In a standard module, it contains the following UDF:

Please Login or Register  to view this content.

In Cell E2 is the formula (which is then copied down):
=YearList(C2,D2)

Hope that helps,
~tigeravatar

Thanks tigeravtar and romper that helps a lot but in my worksheet years are entered with preceding zeros
like 01 , 02

Can u make it work in above scenerio too pls?

@netvasi: Confirmed that it still works with preceding 0's, even if the years are formatted as text. Did you give it a try?

@Romperstomper: thanks for the info, I'll read more up on it. I've just gotten used to putting it in every UDF, hehe