Forum Discussion
Table for invoice number
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.
As a 365 dynamic array
= LET(
k, SEQUENCE(108,1,0),
m, QUOTIENT(k,3),
date, EDATE(start,m),
seq, 1+MOD(k,3),
TEXT(date,"mm.yy-")&seq )seems to work.
PeterBartholomew1 yeah, i think you'll need to guide me to use that ^^"
I'm quite skilled in the basics of excel with formulas and so on, but i don't know how to use VBA and other things
I can see why you are confused, but the formula is just a standard worksheet formula in Excel 365!
LET is a new worksheet function that uses an alternating pattern of parameters to define names (variables) and the formulas that they refer to. SEQUENCE is another function that I have used to generate an index column but in legacy Excel this would be done with ROW().
The key question is do you have access to Excel 365? It is very different from anything that has gone before.
- 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.