Sir,
This is good formula and it working also. But 1. Fiscal year starts from
April to March. 2. If b4 is 0, a3+1,"") 3. According to System Date. So
please tell me how to set this formula.

Regards

Rao Ratan Singh

"Fred Smith" wrote:

When does your fiscal year start? What determines what fiscal year you are in --
the system date or some other cell?

If you are using a calendar year, and the system date, change the "A4+1" part
of your formula to:

=year(today())*100000+mod(a4,100000)+1

--
Regards,
Fred


"Rao Ratan Singh" wrote in message
...
Hi there,
I m keeping inventory record in excel sheet using my Item ID like this -
200600001 and so on by entering formula==IF(B50,A4+1,""). Presently 258
items i have entered in this finacial year and las ID number is 200600258.

But is there any way that for whole financial year 2006-07 it works in this
manner 200600001 and son and as just as next financial 2007-08 comes and what
product inventory falls in this new year it automatically starts from
200700001 and so on.

I hope for best simple formula.