Worknum on concatinated date format

[bonbrian]

Please help on how to get the workweek using worknum function on a concatinated date format
=CONCATENATE(A1," ",B1," ",C1)
how can i use the worknum function for this formula?

 

[etaf]

whats worknum ?
do you mean WeekNUM()


where do you want to add the weeknum()

You could use text join () as you have 365 version and join a range together as well as the weeknum

i need a little more info then provided

heres an example

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

 

[etaf]

showing the range possibility with TEXTJOIN

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

 

[bonbrian]

Thank you, yeah it should be WeekNUM()
What i mean is if i combine the cells with month day year using concatinate or textjoin, how can i convert it to workweek.

 

[etaf]

you would need to concatenate the cells and then use datevalue() to change to a date and then weeknum() to get the weeknumber

I'm in UK and used DD/MMMM/YYYY type of format - so C2 & B2 & D2

OR with a textjoin

Kitchen-Order-ETAF.xlsx
	A	B	C	D	E	F	G
1		Month	Day	year		WORKWEEK
2		December	25	1999		52
3
4					TEXTJOIN	52
5
Sheet6

Cell Formulas
Range	Formula
F2	F2	=WEEKNUM(DATEVALUE(C2&" "&B2&" "&D2))
F4	F4	=WEEKNUM(DATEVALUE(TEXTJOIN("-",1,C2,B2,D2)))

 

[bonbrian]

Thank you

 

[etaf]

you are welcome