Hello all..

I have this number format: 1655-01-32 and I need to have a formula that will increase the middle number by 1, for example 1655-01-32 incremented to 1655-02-32, then 1655-03-32, etc.

What i wanted to do is type in the first number (1655-01-32), then have it auto increment 9 other times.

Any help would be appreciated.

-David