Hi here is how acheived what you are looking for: (In Excel 2003)

Let's assume that everything starts in cell a1.

Qty Start Serial End Serial
5 1 =a2-b2
3 =c2+1 =b3+a3-1

Copy b3 to c3 down however many rows you need. To get the leading zeros you
will have to create a custom format:
Select a cell or cells affected
Select Format from the menu
Select cells
Select the Number tab in the dialog box
Select Custom
Type 0000# in the Type text box. Copy the format to all of the cells
affected.

If this helps please press Yes

John

"irealtymods" wrote:

i am looking for formula to generate serial numbers and date, and when i
enter qty other cells filled with data.
so:
qty serial start serial last date
5 00001 00004 090730
3 00005 00007 090730

and so on

thank you for your help.