Kitchen-Order-ETAF.xlsx | |||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | J | K | |||
1 | Concatenate | text join | Concat using & | ||||||||||
2 | This is | 5/1/21 | Week Number | This is 18 Week Number | This is 18 Week Number | This is 18 Week Number | |||||||
Sheet5 |
Cell Formulas | ||
---|---|---|
Range | Formula | |
E2 | E2 | =CONCATENATE(A2," ",WEEKNUM(B2)," ",C2) |
H2 | H2 | =TEXTJOIN(" ",1,A2, WEEKNUM(B2),C2) |
K2 | K2 | =A2&" "&WEEKNUM(B2)&" "&C2 |
Kitchen-Order-ETAF.xlsx | ||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | J | K | L | |||
1 | ||||||||||||||
2 | This | is | the | Date | for | 5/1/21 | Week | Number | ||||||
3 | ||||||||||||||
4 | ||||||||||||||
5 | Concatenate | text join | Concat using & | |||||||||||
6 | This is the Date for18 Week Number | This is the Date for 18 Week Number | This is the Date for18 Week Number | |||||||||||
7 | ||||||||||||||
8 | ||||||||||||||
9 | ||||||||||||||
Sheet5 |
Cell Formulas | ||
---|---|---|
Range | Formula | |
A6 | A6 | =CONCATENATE(A2," ",B2," ",C2," ",D2," ",E2,WEEKNUM(F2)," ",G2," ",H2) |
F6 | F6 | =TEXTJOIN(" ",1,A2:E2,WEEKNUM(F2),G2:H2) |
K6 | K6 | =A2&" "&B2&" "&C2&" "&D2&" "&E2&WEEKNUM(F2)&" "&G2&" "&H2 |
Cell Formulas | ||
---|---|---|
Range | Formula | |
F2 | F2 | =WEEKNUM(DATEVALUE(C2&" "&B2&" "&D2)) |
F4 | F4 | =WEEKNUM(DATEVALUE(TEXTJOIN("-",1,C2,B2,D2))) |