Forum Discussion
calculate and display Date formula+Suffix
Hello! Part of my trouble may be that I'm not familiar enough with the proper formula terms to search effectively, however, here's my dilemma: I'm attempting to display what amounts to FORMULA w...
Hi Hinkleberg
As per my understanding, you need to input the project date, and then based on that date you want to generate the project serial number automatically. Your target serial number must contain the date and a two-digit suffix that is incremental.
By using TEXT() and CONCATENATE() functions, I have tried to formulate your requirement in the attached sample file.
You only need to input the project dates in the green highlighted cells.
Please check it out and let me know if it works for you.
Thanks
Tauqeer