Time Being Added to a Date and Day Concatenation

Mellow

Hi,

I am setting up a scheduling report for my Team and would like to group each task in the report by a column that is a concatenation of the task start date with the day of the week for that date (e.g., 12/20/24 - Friday). When I create this concatenation using the formula below it works, but also adds a time of day into the output (see image below).

=[Start Date]@row + " " + [Day of Week]@row

Please see the additional information below that may be relevant.

• The column type is 'Date'. Changing to a text/number type does not remove the time.
• I am aware that you can change the date format in a column to have the day of the week in addition to the date (e.g., Fri 12/20/24). Unfortunately, when I create the groupings in the report this formatting does not carry over to the group titles. It removes the day of week and only shows the date.

Any thoughts on how to get rid of that time of day?!?

Melissa Yamada

Hello @Mellow

Try this:

=LEFT([Start Date]@row, 8) + " " + [Day of Week]@row

Mark.poole

Am I right in assuming you are using a Created date column as your start date column.

If this is the case try this formula

=DATEONLY([Start Date]@row) + " " + [Day of Week]@row