I need a serial number generated from a couple of sources. One is a "Unit
Number" column and the other is a "Date Column". I need the date to be
converted from mm/dd/yy in one cell to yy***. *** being the day of the year
that the serial number was created. how can I do this? Thanks.