Forum Discussion

Hinkleberg's avatar
Hinkleberg
Copper Contributor
Jun 23, 2022

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/ SUFFIX where the suffix is itself another formula.  Complicating it is that the main formula uses incremental MMDDYY, and the suffix is an incrementing 2-digit number.

 

Why? I want to define a date in one cell (for instance, 12/01/2022), then calculate what will be used as a simple project code, in the form of 12012201, 12012202, 12012203 etc.

 

I'll also need to increment the date, generating 12022201, 12022202, and so on. The final layout will be what looks like a project calendar, without manually entering every single serial number.

 

I've botched it.  So I'm looking to the experts!

 

Thank you!

 

 

 

 

excel
Formulas and Functions

1 Reply

Sort By
  • tauqeeracma's avatar
    tauqeeracma
    Steel Contributor
    Jun 25, 2022

    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

Resources