My invoice number codes are made from using the date. For instance the first invoice for today would be 20180326001 (yyyymmdd001), the second today would be 20180326002 (yyyymmdd002). I am trying to get these codes to generate automatically from Excel when I enter the date I create the invoice... for instance I date each invoice the day I create it: 26/03/18, is there a way to generate an invoice code from the date?
Solved by A. W. in 25 mins