Convert 3 columns to day name

[thedeadzeds]

Guys, whats the best way to convert column a, b and c to the format in the Date name column?

Thanks

Day	Month	Year	Day Name
1	September	2023	Friday

 

[felixstraube]

You can do this

Formatting the cell to "dddd"

Book1
	A	B	C	D
1	1	september	2023	Friday
Sheet1

Cell Formulas
Range	Formula
D1	D1	=DATEVALUE(TEXTJOIN(" ",,A1:C1))

Or this:

Book1
	A	B	C	D
1	1	september	2023	Friday
Sheet1

Cell Formulas
Range	Formula
D1	D1	=TEXT(DATEVALUE(TEXTJOIN(" ",,A1:C1)),"dddd")

 

[RobP]

or this way

=TEXT(DATEVALUE(A1&B1&C1),"dddd")

Kudos to Felix.. I hadn't figured out the "dddd" bit on the end !

 

[Scott Huish]

The DATEVALUE part isn't necessary.

=TEXT(A1&B1&C1,"dddd")

 

[felixstraube]

Oh, thanks! Didn't know TEXT did the text to date conversion like DATEVALUE.