Format date formula

Hi everyone,

I am trying to solve a relatively easy thing but can’t seem to find a solution myself.

I have a board with a timeline column. However, i needed to display the day from that timeline so i’ve added a formula column to display it:

However, when the dates are across multiple days (see the last line in the above), i’d like the date column to display “Thursday (start date) to Sunday (end date)”.

Is there a way to do this with formulas?

If not, any ideas would be very welcomed!

Thanks.

1 Like

Use the following formula. But use straight quotation marks.

IF(Days({Timeline#End},{Timeline#Start})>0,
CONCATENATE(
FORMAT_DATE({Timeline#Start}, “dddd”),
" to ",
FORMAT_DATE({Timeline#End}, “dddd”)),
FORMAT_DATE({Timeline#Start}, “dddd”))

This worked!

Thank you so much!

1 Like

Hey @Bree

Good job on the formula!

FYI, if you use the “preformatted text” formatting option, you won’t have to worry about the quotation marks. For example:

IF(Days({Timeline#End},{Timeline#Start})>0,
CONCATENATE(
FORMAT_DATE({Timeline#Start}, "dddd"),
" to ",
FORMAT_DATE({Timeline#End}, "dddd")),
FORMAT_DATE({Timeline#Start}, "dddd"))

was inserted like this:


Jim - The Monday Man

1 Like