Razzio
@razzio.bsky.social
The second option would be to piece together the individual parts, then combine them. In the screenshot, I put the day name in A2, the date in B2, and this formula in B3:
=CONCAT(A2, ", ", TEXT(B2, "m/d/yyyy"))
(3 / ?)
=CONCAT(A2, ", ", TEXT(B2, "m/d/yyyy"))
(3 / ?)
December 30, 2024 at 10:41 PM
The second option would be to piece together the individual parts, then combine them. In the screenshot, I put the day name in A2, the date in B2, and this formula in B3:
=CONCAT(A2, ", ", TEXT(B2, "m/d/yyyy"))
(3 / ?)
=CONCAT(A2, ", ", TEXT(B2, "m/d/yyyy"))
(3 / ?)
The first option is to accept the formatting of "Wednesday, January 1, 2025." To do that, put "1/1/25" in a cell. Right-click that cell and select "Format Cell." Navigate to the option in the screenshot. Click "OK," then grab the handle in the bottom right of the cell and drag down. (2 / ?)
December 30, 2024 at 10:37 PM
The first option is to accept the formatting of "Wednesday, January 1, 2025." To do that, put "1/1/25" in a cell. Right-click that cell and select "Format Cell." Navigate to the option in the screenshot. Click "OK," then grab the handle in the bottom right of the cell and drag down. (2 / ?)