Custom function or calculation
kindly help me make a custom function or calculation that generates a Product Lot Number base on the last two Digit of a Year for the first two digits, the second two digits the number of the month and the last three digits are sequential of three digits starting with 001 base from the number of materials received from that month. below is an example.
First two digits (06) - Year
2nd two digits (09) - Month
3rd 3 digits (001) - number of material arrived from that particular month