Forum Discussion
Solved
Table for invoice number
Hello, i have a simple question to ask. I have a file in excel that i use to print the invoice for my work and also to store the data of the client and the link to the previous invoice. In one of...
For example in row 1:
=TEXT(MOD(QUOTIENT(ROW()-1,3),12)+1,"00")&".""IENT(ROW()-1,36)+18&"."&MOD(ROW()-1,3)+1
And then fill down as far as you want. This version will start with 01.18.1 for 2018. If you want to start in a different year, change 18 in the formula.
I'm sorry for the delay in the response. Unfortunately i do not have acces to Excel 365, my copy of Excel comes from a suite of Office Professional Plus 2019.
For example in row 1:
=TEXT(MOD(QUOTIENT(ROW()-1,3),12)+1,"00")&".""IENT(ROW()-1,36)+18&"."&MOD(ROW()-1,3)+1
And then fill down as far as you want. This version will start with 01.18.1 for 2018. If you want to start in a different year, change 18 in the formula.
- Thanks, i couldn't use the one you wrote (i've tried to translate in italian but some function does not translate exactly), but with this i was able to make a new one that works perfectly. I've used
=TEXTJOIN(".",TRUE,TEXT(ROW()-3;"00"),RIGHT(B4,2))
So for example this is the one in the cell A4. In B4 i wrote the year as a four digit number and all i have to do is change the year whenever i print the last invoice of the year and change the -3 based on whatever the number of the row is the for the first invoice of the new year.Glad that you found a solution. The Italian version of the formula that I posted would be
=TESTO(RESTO(QUOZIENTE(RIF.RIGA()-1;3);12)+1;"00")&"."&QUOZIENTE(RIF.RIGA()-1;36)+18&"."&RESTO(RIF.RIGA()-1;3)+1