I am trying to find a way to create a unique serial number based upon the
current julian date + an increment counter.

I have sort of done this however the julian date function is not static and
all the serial numbers change each day. I need to create be able to create
the serial number (maybe by clicking on a cell) and then once the number
populates the cell, it remains fixed.

Any suggested would be welcome.