As an example, I have sales reports generated month and sometimes bi-monthly. Instead of relying on the date stamp of the report, I would like name the reports Sales001 - Sales012. Sometimes an additional report will be generated in the same month, so that would be Sales001b, etc. The dates are always mm/dd/yyyy, so reports ran on 10/10/2016 and 10/31/2016 would be Sales010 and Sales010b.
Any advice on a calculation for the above scenario?
It sounds like you want something similar to this thread:
The specified item was not found.